oracle impdp compilation,impdp Wrapped PLSQL package body invalid corrupted with error ORA-39082 & P...

一套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 手动创建。

打赏

微信扫一扫，打赏作者吧～