AWS RDS IMPORT,

Question

I am trying to import AWS RDS using multiple dump files and multiple schemas. I get an error when I use multiple dump files,

DECLARE
hdnl NUMBER;
BEGIN
hdnl := DBMS_DATAPUMP.OPEN( operation => 'IMPORT', job_mode => 'SCHEMA', job_name=>null);
DBMS_DATAPUMP.ADD_FILE( handle => hdnl, filename => 'bjs58e_RECIDIVISM.dmp', 'exp_bjs58e_NCVS.dmp',
directory => 'DATA_PUMP_DIR',
filetype => dbms_datapump.ku$_file_type_dump_file);
DBMS_DATAPUMP.ADD_FILE( handle => hdnl, filename => 'imp-ncvs_recidivism.log', directory => 'DATA_PUMP_DIR', filetype => dbms_datapump.ku$_file_type_log_file);
DBMS_DATAPUMP.METADATA_FILTER(hdnl,'SCHEMA_EXPR','IN (''RECIDIVISM'',''NCVS'')');
DBMS_DATAPUMP.START_JOB(hdnl);
END;
/  2    3    4    5    6    7    8    9   10   11   12
DBMS_DATAPUMP.ADD_FILE( handle => hdnl, filename => 'bjs58e_RECIDIVISM.dmp', 'exp_bjs58e_NCVS.dmp',
                                                                             *
ERROR at line 5:
ORA-06550: line 5, column 78:
PLS-00312: a positional parameter association may not follow a named association
ORA-06550: line 5, column 1:
PL/SQL: Statement ignored

what should be the correct syntax when I have multiple dump files bjs58e_RECIDIVISM.dmp', 'exp_bjs58e_NCVS.dmp', in DBMS_DATAPUMP.ADD_FILE, when I have a single file I do not get an error

rePost-User-1211029 · Answer

Even this statement gives me an error, when I have DBMS_DATAPUMP.ADD_FILE for each dump files

DECLARE
hdnl NUMBER;
BEGIN
hdnl := DBMS_DATAPUMP.OPEN( operation => 'IMPORT', job_mode => 'SCHEMA', job_name=>null);

DBMS_DATAPUMP.ADD_FILE(
  handle    => hdnl,
  filename  => 'bjs58e_RECIDIVISM.dmp',
  directory => 'DATA_PUMP_DIR',
  filetype  => dbms_datapump.ku$_file_type_dump_file
);

DBMS_DATAPUMP.ADD_FILE(
  handle    => hdnl,
  filename  => 'exp_bjs58e_NCVS.dmp',
  directory => 'DATA_PUMP_DIR',
  filetype  => dbms_datapump.ku$_file_type_dump_file
);

DBMS_DATAPUMP.ADD_FILE( handle => hdnl, filename => 'imp-ncvs_recidivism.log', directory => 'DATA_PUMP_DIR', filetype => dbms_datapump.ku$_file_type_log_file);
DBMS_DATAPUMP.METADATA_FILTER(hdnl,'SCHEMA_EXPR','IN (''RECIDIVISM'',''NCVS'')');
DBMS_DATAPUMP.START_JOB(hdnl);
END;
/
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 4929
ORA-06512: at "SYS.DBMS_DATAPUMP", line 5180
ORA-06512: at line 13

AWS RDS IMPORT,

Relevant content