By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Export Error with Oracle RDS

0

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,

Topics
Migration & ModernizationAnalyticsDatabaseManagement & Governance
Tags
Amazon Relational Database ServiceAWS Management ConsoleExtract Transform & Load DataOracleRDS Custom for SQL Oracle
Language
English
sam15
asked a year ago626 views
1 Answer
0
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

profile pictureAWS
EXPERT
Didier_Durand
answered a year ago
profile picture
EXPERT
Adeleke Adebowale Julius
reviewed a year ago
  • sam15
    a year ago

    I should have mentioned this is an Oracle SE so data compression is not available, The DB is not that big and might be 8-9 GB so I did not want multiple dump files but rather change the FILESIZE parameter to the max vailable. Also, I am using SQL Developer GUI (not SQL Plus) to connect to RDS and one link you pointed out is more of a connection to EC2 where you have full access to Operating system prompt. With RDS we dont.

  • Didier_Durand EXPERT
    a year ago

    Hi Sam15, thanks for accepting for my answer!

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

Relevant content