ORA-39082: Object type ALTER_FUNCTION:"XXXX"."F_cccc" created with compilation

来源:这里教程网 时间:2026-03-03 17:50:44 作者:

一个库(版本是11g -11.2.0.4)本地做了数据泵导出全库备份,然后再IMPDP回去的时候就发生了报错。存储过程和trigger都不能创建。ORA-39082: Object type ALTER_FUNCTION:"XXXX"."F_cccc" created with compilation warningsORA-39082: Object type ALTER_FUNCTION:"XXXX"."F_ddd" created with compilation warningsProcessing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/ALTER_PROCEDUREORA-39082: Object type ALTER_PROCEDURE:"XXXX"."ccc" created with compilation warningsORA-39082: Object type ALTER_PROCEDURE:"XXXX"."ddd" created with compilation warningsORA-39082: Object type ALTER_PROCEDURE:"XXXX"."ccc" created with compilation warningsORA-39083: Object type ALTER_PROCEDURE failed to create with error: MOS上的说法这是个BUG。 但是IMPDP的命令指定include=trigger的时候就可以正常导入。

相关推荐