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 2021Copyright (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去掉即可正常导入.