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

Question

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

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

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

Govardhanan_R · Answer

Hi,
---
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.

Govardhanan.

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

Hi,

Relevant content