ORA-39082: Object type ALTER_FUNCTION:"XXXX"."F_cccc" created with compilation
一个库（版本是11g -11.2.0.4）本地做了数据泵导出全库备份，然后再IMPDP回去的时候就发生了报错。
存储过程和trigger都不能创建。
ORA-39082: Object type ALTER_FUNCTION:"XXXX"."F_cccc" created with compilation warnings
ORA-39082: Object type ALTER_FUNCTION:"XXXX"."F_ddd" created with compilation warnings
Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/ALTER_PROCEDURE
ORA-39082: Object type ALTER_PROCEDURE:"XXXX"."ccc" created with compilation warnings
ORA-39082: Object type ALTER_PROCEDURE:"XXXX"."ddd" created with compilation warnings
ORA-39082: Object type ALTER_PROCEDURE:"XXXX"."ccc" created with compilation warnings
ORA-39083: Object type ALTER_PROCEDURE failed to create with error:
MOS上的说法这是个BUG。
但是IMPDP的命令指定include=trigger的时候就可以正常导入。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/69976387/viewspace-2914434/ ，如需转载，请注明出处，否则将追究法律责任。
最新文章
- ORA-00445: background process "m000" did not start after 120 seconds host:xxxx
- MYSQL : ERROR 1045 (28000): Access denied for user 'root'@'localhost'
- ORA-00235: control file read without a lock inconsistent due to concurrent updat
- ORA-31693 ORA-00001
- 由于IMPDP...APPEND引起的 enq: TM – contention
- ORACLE-RMAN自动备份和恢复
- Oracle 11g RAC + DG安装详解--05
- Oracle 11g RAC + DG安装详解--04
- Oracle 11g RAC + DG安装详解--03
- Oracle 11g RAC + DG安装详解--02
