Export Error with Oracle RDS

Question

Hi,

When I try to export (expdp) a database schema in Oracle RDS using SQL Developer, I get the error below related to dump file size.  This seems to be caused by default FILESIZE parameter in AWS RDS. Can I increase the size of this parameter in RDS so export will not fail?

Also, is it possible to generate/store the dump file on client machine where SQL Developer runs or not?

```
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
ORA-39095: Dump file space has been exhausted: Unable to allocate 4096 bytes
Job "SYSAWS"."EXP_SD_3558" stopped due to fatal error at Fri May 10 23:37:29 2024 elapsed 0 00:00:47

```

Thanks,

Accepted Answer

Hi,

Solution for this problem presented at https://www.funoracleapps.com/2024/04/datapump-export-expdp-error-ora-39095.html

You should combine with https://docs.aws.amazon.com/whitepapers/latest/strategies-migrating-oracle-db-to-aws/data-migration-using-oracle-data-pump.html#using-oracle-data-pump-to-export-data-on-the-source-instance to get you use case to work

Best,

Didier

Export Error with Oracle RDS

Contenido relevante