[oracle@hnrs expdp]$impdp \'/as sysdba\' schemas=jxxl dumpfile=full%U.dmp logfile=impdp.log directory=EXPDP DIR02 paral1e1=8

Import: Release 11.2.0.4.0-Production on Tue Mar 25 10:42:29 2025

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-31626:job does not exist

ORA-31633:unable to create master table "SYS.SYS_IMPORT_SCHEMA_01"

ORA-06512:at"SYS.DBMS SYS_ERROR", line 95

ORA-06512:at"SYS.KUPV$FT", line 1038

ORA-04045:errors during recompilation/revalidation Of HNSI.ODTAC_SOURCELOG

ORA-01031:insufficient privileges

检查文件系统、directory、用户权限均正常，并且导入过一次也正常。

根据报错查看编译出错的对象

ORA-04045:errors during recompilation/revalidation Of HNSI.ODTAC_SOURCELOG

查询对象

select owner,object_name,object_type from dba_objects where object_name='ODTAC_SOURCELOG'

OWNER OBJECT_NAME OBJECT_TYPE

-------------- --------------------- -----------------------

HNSI ODTAC_SOURCELOG TRIGGER

发现是个触发器，并且重编译发生错误，所以干脆删掉

drop trigger HNSI.ODTAC_SOURCELOG

再次导入正常。