首页 » ORACLE » impdp Wrapped PLSQL package body invalid corrupted with error ORA-39082 & PLS-00753

impdp Wrapped PLSQL package body invalid corrupted with error ORA-39082 & PLS-00753

一套11.2.0.4 环境做数据库迁移使用expdp生成dump文件,impdp的方法,确认原数据库中对象有效,多次尝试始终有package body无效, 用impdp SQLFILE生成的SQL DDL发现是WRAPED 加密后的。 这里简单记录

导入时提示
ORA-39082 Object type PACKAGE_BODY: created with compilation warnings.

SQL> alter package xx.xx compile body;
Warning: Package Body altered with compilation errors.

SQL> show error
LINE/COL ERROR
——– —————————————————————–
0/0 PLS-753: malformed or corrupted wrapped unit

MOS中确认在11.2.0.4-12.2版本存在的Bug 18881811 Data Pump Import of Wrapped PLSQL Corrupts the Body,
This problem is introduced in 11.2.0.4 and 12.1.0.2 data pump import.

Importing a dumpfile containing a wrapped package (or other PLSQL source) that has the SQL
terminator character ‘/’ as the first or last character of any line of the wrapped text raises a PLSQL error.

触发是当sql中有‘/’开头或结尾的字符时,impdp创建损毁。这个案例中分析发现确实存在注释语句有’/‘结尾。 修复方法目前是导入后找原始DDL sql 手动创建。

打赏

, ,

目前这篇文章还没有评论(Rss)

我要评论