ORA-39001: invalid argument value while importing data dump file in aws rds for oracle.


I am importing the data dump file that I have downloaded from S3.

-----load schema
v_hdnl NUMBER;
v_hdnl := DBMS_DATAPUMP.OPEN(operation => 'IMPORT', job_mode => 'SCHEMA', job_name=> 'impjob21', version => '');
    handle    => v_hdnl, 
    filename  => 'abc.dmp', 
    directory => 'DATA_PUMP_DIR', 
    filetype  => dbms_datapump.ku$_file_type_dump_file);

getting the following error: Error report - 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 5 39001. 00000 - "invalid argument value" *Cause: The user-specified API parameters were of the wrong type or value range. Subsequent messages supplied by DBMS_DATAPUMP.GET_STATUS will further describe the error. *Action: Correct the bad argument and retry the API.

Note: before starting the job, I am getting errors. exporting file created in on-premise Oracle instance 11g database. I have followed the steps mentioned in the documentation. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Oracle.Procedural.Importing.DataPump.html

1 Answer


I tried this operation, and after a few trials and errors, I was able to get exactly the same message that you got when I gave the dump file name incorrectly. So, please double check the file name ('abc.dmp') that you have given - maybe it is not correct?

To verify its existence, you could run the following SQL: select filename from table(RDSADMIN.RDS_FILE_UTIL.LISTDIR('DATA_PUMP_DIR')) where type='file' ;

If the above approach does not resolve this, I would then recommend that you open a support case with AWS Support to investigate further.


profile pictureAWS
answered 3 months 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