在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)
- )
- )