首页 新闻 会员 周边

Oracle 11g备份导入12c错误

0
悬赏园豆:100 [待解决问题]

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_DATA01
FJCPP_TEMP01 
FJCPP
DUMP_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: 文件操作无效
cyclone119的主页 cyclone119 | 初学一级 | 园豆:90
提问于:2019-07-17 18:03
< >
分享
所有回答(1)
0

用exp、imp操作是正常的。

Oracle 11g导出:
exp FJCPP/FJCPP FILE=F:\dump\FJCPP_20190717_2227_137.dmp
Oracle 12c导入:
imp FJCPP/FJCPP@ORCLPDB FILE=C:\dump\FJCPP_20190717_2227_137.dmp full=y ignore=y

cyclone119 | 园豆:90 (初学一级) | 2019-07-18 14:33
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册