问题描述
明明已经创建zwfw用户但是impdp导入依旧提示ORA-39165: Schema ZWFW was not found.
--创建用户语句
sys@TOPDH 2023-12-26 10:38:11> create user zwfw identified by "oracle" ;
User created.
sys@TOPDH 2023-12-26 10:38:26> grant dba,connect,resource to zwfw;
Grant succeeded.
--导入
[oracle@top132:/home/oracle]$ impdp ZWFW/oracle@topdh schemas=ZWFW directory=DATA_PUMP_DIR dumpfile=20231225200620_topeocps_yasuo.dmp logfile=zwfw_`date +"%Y%m%d%H%M%S"`.log remap_tablespace=TOPEOCPS:USERS REMAP_SCHEMA=TOPEOCPS:ZWFW parallel=4
Import: Release 11.2.0.4.0 - Production on Tue Dec 26 10:41:20 2023
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39165: Schema ZWFW was not found.
解决办法
去掉 schemas=ZWFW ，REMAP_SCHEMA时不需指定schemas，若不存在schemas会自行创建，若存在schemas提示已存在。
--导入
[oracle@top132:/home/oracle]$ impdp ZWFW/oracle@topdh schemas=ZWFW directory=DATA_PUMP_DIR dumpfile=20231225200620_topeocps_yasuo.dmp logfile=zwfw_`date +"%Y%m%d%H%M%S"`.log remap_tablespace=TOPEOCPS:USERS REMAP_SCHEMA=TOPEOCPS:ZWFW parallel=4
Import: Release 11.2.0.4.0 - Production on Tue Dec 26 10:41:20 2023
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39165: Schema ZWFW was not found.
