Error ORA-39001 When Using DBMS_DATAPUMP API Over A Network Link (Doc ID 1160207.1)

Last updated on NOVEMBER 27, 2012

Applies to:

Oracle Server - Enterprise Edition - Version 10.1.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 27-NOV-2012***

Symptoms

When running a PL/SQL block containing calls to DBMS_DATAPUMP the following errors are raised:

declare
*
ERROR at line 1:
ORA-39001: invalid argument value
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3444
ORA-06512: at "SYS.DBMS_DATAPUMP", line 5233
ORA-06512: at line 4

The following anonymous PL/SQL block was used:

declare
  h1 NUMBER;
begin
   h1 := dbms_datapump.open (operation => 'IMPORT', job_mode => 'SCHEMA', remote_link => 'PRODUCTION', job_name => 'HR_IMPORT_24072010', version => 'COMPATIBLE');
   dbms_datapump.set_parallel (handle => h1, degree => 1);
   dbms_datapump.add_file (handle => h1, filename => 'IMPORT24072010.LOG', directory => 'DATA_PUMP_DIR', filetype => 3);
   dbms_datapump.set_parameter (handle => h1, name => 'KEEP_MASTER', value => 0);
   dbms_datapump.metadata_filter (handle => h1, name => 'SCHEMA_EXPR', value => 'IN(''ALSARF'')');
   dbms_datapump.set_parameter (handle => h1, name => 'INCLUDE_METADATA', value => 1);
   dbms_datapump.set_parameter (handle => h1, name => 'ESTIMATE', value => 'BLOCKS');
   dbms_datapump.set_parameter (handle => h1, name => 'TABLE_EXISTS_ACTION', value => 'REPLACE');
   dbms_datapump.set_parameter (handle => h1, name => 'SKIP_UNUSABLE_INDEXES', value => 0);
   dbms_datapump.start_job (handle => h1, skip_current => 0, abort_step => 0);
   dbms_datapump.detach (handle => h1);
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