[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
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-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
再次导入正常。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22967847/viewspace-3078962/ ，如需转载，请注明出处，否则将追究法律责任。
