ORA-39002 ORA-39168

impdp导入报错ORA-39002 ORA-39168

$ impdp \'/ as sysdba\'  parfile=impdp.par
Import: Release 11.2.0.4.0 - Production on Fri Apr 16 10:57:13 2021

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, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORA-39002: invalid operation						#无效的操作
ORA-39168: Object path TRIGGER was not found.		#找不到触发器对象路径 
ORA-39168: Object path SYNONYM was not found.		#找不到同义词对象路径
ORA-39168: Object path FUNCTION was not found.		#找不到函数对象路径
ORA-39168: Object path PROCEDURE was not found.		#找不到程序对象路径

$
 
#impdp.par导入文件中EXCLUDE部分内容如下：
EXCLUDE=(STATISTICS,PROCEDURE,FUNCTION,SYNONYM,GRANT,TRIGGER,index)

报错：
无效的操作、找不到触发器对象路径等.

原因：
因为在导出时，表中就没有TRIGGER、SYNONYM、FUNCTION、PROCEDURE等，所以在导入时指定EXCLUDE(排除)这些参数就会报错。

解决:
将报错的参数从导入文件impdp.par去掉即可正常导入.