oracle 数据泵还原数据故障

问题遇到的现象和发生背景

oracle数据库中impdp导入数据出现大量报错

用代码块功能插入代码，请勿粘贴截图

导出语句
expdp dmp/dmp directory=dir_dp dumpfile=wms20221124$BAKUPTIME%U.dmp content=all full=y logfile=wms20221124$BAKUPTIME.log parallel=8 cluster=n COMPRESSION=all
导入语句
nohup impdp dmp/dmp directory=dir_dp dumpfile=wms20221124%U.dmp exclude=user schemas=WMS_V431_STD,SEC_V431_STD,DATAHUB_TEST,SEC_USER_PRD logfile=impdp_wms20221125.log parallel=8 cluster=n &

运行结果及报错内容

Starting "DMP"."SYS_IMPORT_SCHEMA_05": dmp/******** directory=dir_dp dumpfile=wms20221124%U.dmp exclude=statistics schemas=WMS_V431_STD,SEC_V431_STD,DATAHUB_TEST,SEC_USER_PRD logfile=impdp_wms20221125.log parallel=8 cluster=n
Processing object type DATABASE_EXPORT/SCHEMA/USER
ORA-31684: Object type USER:"DATAHUB_TEST" already exists
ORA-39083: Object type USER failed to create with error:
ORA-10615: Invalid tablespace type for temporary tablespace
Failing sql is:
CREATE USER "SEC_USER_PRD" IDENTIFIED BY VALUES 'S:C343D3A96926C09A070D61EE277B273B01C4C697A3CE38370EEC12ACB282;57928AEE3CC28FF9' DEFAULT TABLESPACE "SEC_USER_PRD" TEMPORARY TABLESPACE "SEC_USER_PRD_TMP"
大量报错
Failing sql is:
BEGIN
sys.dbms_logrep_imp.instantiate_schema(schema_name=>SYS_CONTEXT('USERENV','CURRENT_SCHEMA'), export_db_name=>'ORCL', inst_scn=>'336778821');COMMIT; END;
ORA-39083: Object type PROCACT_SCHEMA failed to create with error:
ORA-31625: Schema SEC_V431_STD is needed to import this object, but is unaccessible
ORA-01435: user does not exist
大量类似报错
ORA-39151: Table "DATAHUB_TEST"."STD_DOC_SALESORDER_HEADER" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
大量类似报错
CREATE TABLE "WMS_V431_STD"."IND_PHARM_SKU_ATTACHMENT" ("CUSTOMERID" VARCHAR2(30 BYTE) NOT NULL ENABLE, "SKU" VARCHAR2(50 BYTE) NOT NULL ENABLE, "FILESEQ" NUMBER(,0) NOT NULL ENABLE, "ORIGINALFILENAME" VARCHAR2(60 BYTE) NOT NULL ENABLE, "MANDATORY" CHAR(1 BYTE), "LICENSENO" VARCHAR2(200 BYTE), "LICENSE_VALIDPERIOD" NUMBER(,0), "LICENSEALERTDAYS"
ORA-39083: Object type TABLE:"WMS_V431_STD"."IND_PHARM_SKU" failed to create with error:
ORA-01918: user 'WMS_V431_STD' does not exist
大量类似报错
ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"WMS_V431_STD"."SYS_DATAHUB_CONFIGURATION" creation failed
大量类似报错

我的解答思路和尝试过的方法

表空间都有配置

我想要达到的结果

正常导入数据 然后今天中午有结果~

可以做一些设置，导出的时候不带用户信息，这样就不会重建用户信息

错误在于导入时创建用户SEC_USER_PRD时表空间SEC_USER_PRD_TMP"不存在导致用户不能创建，
用户下所有对象不能导入，后续的众多错误。
先创建表空间，例子：
create temporary tablespace "SEC_USER_PRD_TMP" tempfile '\path\SEC_USER_PRD_TMP_001.dbf ' size 50m autoextend on next 50m maxsize 8198M extent management local;
另外建议参照源库，在目标库把空间先创建齐。

参考一下

比较笨的办法: 打开导出的文件进行替换其中的用户名和表空间名成你自己数据库的。

参考