首页 > 数据库 > > Oracle 11g备份导入12c错误
Oracle 11g备份导入12c错误
Oracle11g:用户名:FJCPP 表空间:FYSOFT_DATA01 临时表空间:FYSOFT_DATA01
导入:expdp FJCPP/FJCPP DIRECTORY=dump_dir DUMPFILE=FJCPP_20190717_1517_137.dmp logfile=FJCPP_20190717_1517_137.log SCHEMAS=FJCPP
Oracle12C配置情况:
CDB$ROOT:
FJCPP_DATA01
FJCPP_TEMP01
C##ROOT
DUMP_ROOT
ORCLPDB:FJCPP_DATA01FJCPP_TEMP01 FJCPPDUMP_DIR
Oracle12c自身上的导出、导入正常:
expdp FJCPP/FJCPP@ORCLPDB DIRECTORY=DUMP_DIR DUMPFILE=FJCPP_20190717_TMP.dmp logfile=FJCPP_20190717_TMP.log SCHEMAS=FJCPP
impdp FJCPP/FJCPP@ORCLPDB DIRECTORY=DUMP_DIR DUMPFILE=FJCPP_20190717_TMP.DMP logfile=FJCPP_20190717_TMP.log REMAP_SCHEMA=FJCPP:FJCPP REMAP_TABLESPACE=FJCPP_DATA01:FJCPP_DATA01 table_exists_action=replace
Oracle12c上导入11g备份,错误:
impdp FJCPP/FJCPP@ORCLPDB DIRECTORY=DUMP_DIR DUMPFILE=FJCPP_20190717_1517_137.DMP logfile=FJCPP_20190717_1517_137.log REMAP_SCHEMA=FJCPP:FJCPP REMAP_TABLESPACE=FYSOFT_DATA01:FJCPP_DATA01 table_exists_action=replace
错误内容:ORA-39002: 操作无效ORA-39070: 无法打开日志文件ORA-29283: 文件操作无效ORA-29283: 文件操作无效
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/2551/viewspace-3122332/ ,如需转载,请注明出处,否则将追究法律责任。