oracle-databaseamazon-rdsdatapump

Migration from Oracle Database 11g to AWS RDS Oracle 19c Failures


When Migrating from Oracle Database 11g to AWS RDS Oracle Database 19c using the Oracle Datapump tool for export and the RDS Datapump API for Import resulted in some nasty errors.

ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39143: dump file "/rdsdbdata/datapump/test.dmp" may be an original export dump file

What I have tried


Solution

  • I resolve this issue by doing the following:

    1. Granting permission to the schema to access the directory I was interested in storing the exported DMP file on the server.

    2. Exporting the DMP using expdp (Data Pump)