Import long table list with dbms_datapump

Hi,

I need to import 900 tables (they belong to different schemas - around 15) using data_pump API.


I use following code script:

declare
h1 NUMBER;
begin

h1 := dbms_datapump.open (operation => 'IMPORT', job_mode => 'TABLE', remote_link => 'DL_COREP',

job_name => 'IMPORT_GEN_PL9', version => 'COMPATIBLE');
dbms_datapump.set_parallel(handle => h1, degree => 4);
dbms_datapump.add_file(handle => h1, filename => 'IMPORT_GEN_PARALLEL.LOG', directory =>

'DPUMP_DIR', filetype => 3);
dbms_datapump.set_parameter(handle => h1, name => 'KEEP_MASTER', value => 0);
dbms_datapump.metadata_remap(handle => h1, name => 'REMAP_SCHEMA', old_value => 'GEN', value =>

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