to oracle888() : imp lbas/www.zw04@oa20 file=mydata.dmp tables=test ignore=y,执行的提示为: Import: Release 9.2.0.4.0 - Production on Fri Feb 18 16:23:33 2005Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. IMP-00058: ORACLE error 12154 encountered ORA-12154: TNS:could not resolve service name IMP-00000: Import terminated unsuccessfully 需要说明的是:oa20是15机器上的数据库在oracle client在本地安装的时候,tnsnames里面配置的15机器数据库名,不知道是那里错误,难道非要表空间一样才行?
然后会提示你输入密码的
imp lbas/www.zw04@oa20 file=mydata.dmp tables=test ignore=y,执行的提示为:
Import: Release 9.2.0.4.0 - Production on Fri Feb 18 16:23:33 2005Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
IMP-00058: ORACLE error 12154 encountered
ORA-12154: TNS:could not resolve service name
IMP-00000: Import terminated unsuccessfully
需要说明的是:oa20是15机器上的数据库在oracle client在本地安装的时候,tnsnames里面配置的15机器数据库名,不知道是那里错误,难道非要表空间一样才行?
大表就不要指望exp/imp了