impdp导入报权限问题

[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再次导入正常。