首页 » ORACLE 9i-23ai » 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

  • 2019/11/24
  • ORACLE 9i-23ai
  • 854 views
  • 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 手动创建。

Related Posts:

打赏

, ,

对不起，这篇文章暂时关闭评论。

上一篇：

下一篇：