My Oracle Support Banner

Issues With Wrapped Packages After Impdp (Doc ID 1909287.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.2]
Information in this document applies to any platform.


After importing to a target or a database some wrapped packages are invalid and cannot be compiled.

ORA-39082: Object type PACKAGE BODY:"TC"."MY_PKG" created with compilation warnings

After import with impdp to a database with remap_schema, for the wrapped procedures, the character “/”, which is normally also used as a package body end code, is changed.
For example, the difference is between these lines in or or ...

This package body in is “malformed” and invalid.

Importing a dumpfile containing a wrapped package (or other PLSQL source) that has the SQL terminator character '/' as the last character of a line of wrapped text raises a PLSQL error, e.g.:
  ORA-39082 Object type PACKAGE_BODY:<SCHEMA><PACKAGE_NAME> created with compilation warnings.


Import or migration to or


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.