ORA-39005, ORA-06512 Using DBMS_DATAPUMP With PARTITION_OPTIONS (Doc ID 1060677.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.2.0.2 - Release: 10.2 to 11.2
Information in this document applies to any platform.

Symptoms

Below API running from an 11g database connecting via a dblink  to a 10g database  to pull the tables over.


h1 := dbms_datapump.open (operation => 'IMPORT', job_mode => 'TABLE',remote_link => 'NEMP02.STANWELL.COM', job_name => varJob_name, version => 'COMPATIBLE'); 

dbms_datapump.set_parallel(handle => h1, degree => 1); 

dbms_datapump.set_parameter(handle => h1, name => 'KEEP_MASTER', value => 1); 

dbms_datapump.metadata_filter(handle => h1, name => 'SCHEMA_EXPR', 
value => 'IN(''' || p_src_schema || ''')'); 

dbms_datapump.metadata_filter(handle => h1, name => 'NAME_EXPR',
value => 'IN(''' || p_table_list || ''')'); 

dbms_datapump.set_parameter(handle => h1, name => 'ESTIMATE', value => 'BLOCKS'); 

dbms_datapump.set_parameter(handle => h1, name => 'PARTITION_OPTIONS', value => 'MERGE'); 

dbms_datapump.set_parameter(handle => h1, name => 'INCLUDE_METADATA', value => 0); 

dbms_datapump.set_parameter(handle => h1, name => 'TABLE_EXISTS_ACTION', value => 'TRUNCATE'); 

dbms_datapump.set_parameter(handle => h1, name => 'SKIP_UNUSABLE_INDEXES', value => 1); 

dbms_datapump.start_job(handle => h1, skip_current => 0, abort_step => 0); 

dbms_datapump.detach(handle => h1);


ORA-39005: inconsistent arguments
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3444
ORA-06512: at "SYS.DBMS_DATAPUMP", line 5365
ORA-06512: at "DBMAINT.DATA_PUMP", line 46

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