当我尝试将导入导出到另一个模式的表时,我面临以下问题:
ORA-31696: unable to export/import TABLE_DATA:"schemaowner"."tablename":"SYS_P41" using client specified AUTOMATIC method
ORA-31696: unable to export/import TABLE_DATA:"schemaowner"."tablename":"SYS_P42" using client specified AUTOMATIC method
ORA-31696: unable to export/import TABLE_DATA:"schemaowner"."tablename":"SYS_P43" using client specified AUTOMATIC method
ORA-31696: unable to export/import TABLE_DATA:"schemaowner"."tablename":"SYS_P44" using client specified AUTOMATIC method
我想从一个模式中的表导出所有数据,并将hem导入另一个模式 . 导入期间发生错误 . 以下是我用于导出的命令和导入的命令失败:
expdp schema1/schema1@db1 directory=MYDIR tables=schema1.tbl dumpfile=tbl.dmp logfile=tbl.log content=data_only version=10.2.0.4.0
上面的工作和潮湿文件创建,但在尝试时:
impdp schema2 / schema2 @ db1 directory = MYDIR tables = tbl dumpfile = tbl.dmp logfile = tblload.log content = data_only version = 10.2.0.40 remap_schema = schema1:schema2
上面的错误与开头指定的错误 . 你能告诉我我做错了吗?我真的很感激
另外作为参考,我在oracle 10的linux操作系统上运行命令