AWS RDS IMPORT,

0

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

asked a month ago82 views
1 Answer
0

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);

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

answered a month ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions