ORA-39059 On Schema Import From a Full Export Using Dbms_datapump API (Doc ID 784793.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Standard Edition - Version: 10.2.0.3
This problem can occur on any platform.

Symptoms

ORA-39059 is reported on a Datapump Schema Import using the following syntax:

  SQL>exec schema_impdp('PPLGAGS','GBPPL1P','dpexp_schema_gs','dpimp_schema_gs');

The export dump file is create using DataPump API (dbms_datapump) with these options:

begin
h1 := dbms_datapump.open
(
operation => 'export',
job_mode => 'full',
version => 'compatible'
);

dbms_datapump.add_file
(
handle => h1,
filename => v_export_log,
directory => in_directory,
filetype => DBMS_DATAPUMP.KU$_FILE_TYPE_LOG_FILE
);

dbms_datapump.add_file
(
handle => h1,
filename => v_export_file,
directory => in_directory,
filetype => DBMS_DATAPUMP.KU$_FILE_TYPE_DUMP_FILE
);

dbms_datapump.start_job(h1);

exception
when others then
...
end;

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