Impdp Returns ORA-39082 When Importing Wrapped Procedures (Doc ID 460267.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.3 [Release 10.2]
Information in this document applies to any platform.
***Checked for relevance on 17-Aug-2014***


Symptoms

You created a wrapped procedure/function in source database (important: the database uses a multibyte character set, like UTF8 or similar). Then you started DataPump export utility to export the schema containing the wrapped PL/SQL code and imported the dump either into a target database with multibyte caharacter set, or, into same source database in a new schema.

DataPump import (impdp) returns the following messages:

Import: Release 10.2.0.3.0 - Production on Wednesday, 26 September, 2007 13:49:05

Copyright (c) 2003, 2005, Oracle. All rights reserved.
;;;
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options
Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_FULL_01": system/******** directory=dpu dumpfile=usr001_1.dmp remap_schema=usr001:usr002
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
ORA-39082: Object type ALTER_PROCEDURE:"USR002"."PROC001" created with compilation warnings
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCACT_SCHEMA
Job "SYSTEM"."SYS_IMPORT_FULL_01" completed with 1 error(s) at 13:49:09

Cause

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 hundreds of Community platforms