impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037
在impdp时遇到报错:
Additional information: 3
. . 导入了 "HQ_X1"."T_XX130901":"SP15" 13.99 KB 0 行
. . 导入了 "HQ_X1"."T_XX130901":"SP2" 13.99 KB 0 行
ORA-31693: 表数据对象 "HQ_X1"."TEMP_YEAR_MONTH" 无法加载/卸载并且被跳过, 错误如下:
ORA-31640: 无法打开要读取的转储文件 "/HQ_X22.DMP"
ORA-19505: 无法识别文件"/HQ_X22.DMP"
ORA-27037: 无法获得文件状态
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
我的impdp命令:
nohup impdp HQ_X1/HQ_X1 DUMPFILE=HQ_X1%u.DMP transform=oid:n DIRECTORY=dir1 parallel=8&
看了下官方文档的说法:
The cause of this problem has been identified in unpublished bug 9378256. It is caused by a RAC instance not having physical access to the dump file (as indicated by the DIRECTORY parameter) and using a parallel degree
在impdp时遇到报错:
Additional information: 3
. . 导入了 "HQ_X1"."T_XX130901":"SP15" 13.99 KB 0 行
. . 导入了 "HQ_X1"."T_XX130901":"SP2" 13.99 KB 0 行
ORA-31693: 表数据对象 "HQ_X1"."TEMP_YEAR_MONTH" 无法加载/卸载并且被跳过, 错误如下:
ORA-31640: 无法打开要读取的转储文件 "/HQ_X22.DMP"
ORA-19505: 无法识别文件"/HQ_X22.DMP"
ORA-27037: 无法获得文件状态
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
我的impdp命令:
nohup impdp HQ_X1/HQ_X1 DUMPFILE=HQ_X1%u.DMP transform=oid:n DIRECTORY=dir1 parallel=8&
看了下官方文档的说法:
The cause of this problem has been identified in unpublished bug 9378256. It is caused by a RAC instance not having physical access to the dump file (as indicated by the DIRECTORY parameter) and using a parallel degree