在Oracle学习过程中,使用exp导出数据,使用如下命令:
exp username/password@database_name file=d:\filename.dmp buffer=1048000 tables=(tablename) query=\"where key in (value1)\";
出现错误提示:
EXP-00056: ORACLE error 12154 encountered
ORA-12154: TNS:could not resolve the connect identifier specified
EXP-00000: Export terminated unsuccessfully
发现原因:
app\admin\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora,该文件当中没有对数据库进行类似如下的定义:
database_name=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dest_IP)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = name)
)
)