在oracle中如何导出PDMM31A实例下的IUSER,T2ATTRUPT,T2CLASS,T2LIST,T2TABLE表中的数据,要求表结构和数据一同导出?
我是这样写的:exp sys/change_on_install@PDMM31A file= d:datanewsmgnt.dmp tables=(IUSER,T2ATTRUPT,T2CLASS,T2LIST,T2TABLE) ;可是报这样的错误:
ORA-00900: 无效 SQL 语句
我是这样写的:exp sys/change_on_install@PDMM31A file= d:datanewsmgnt.dmp tables=(IUSER,T2ATTRUPT,T2CLASS,T2LIST,T2TABLE) ;可是报这样的错误:
ORA-00900: 无效 SQL 语句
smgnt.dmp tables=(IUSER,T2ATTRUPT,T2CLASS,T2LIST,T2TABLE)Export: Release 9.2.0.1.0 - Production on 星期一 2月 2 13:21:01 2009Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
EXP-00056: 遇到 ORACLE 错误 12154
ORA-12154: TNS: 无法处理服务名
EXP-00000: 导出终止失败M31A_PDMTSTMSVR为服务器端的数据库
or
ldap.ora isn't pointing to a server with the connect alias you're usingthat could be because they are simply missing, or possibly because of a typo in the alias you're using in your application.
在执行exp命令的机器上,要先定义数据库别名,能连接上后再到处应该就没事了
如果数据库就在执行exp命令的机器上,就不要加@PDMM31A 了