Migrating Oracle 10g Enterprise to AWS RDS oracle 12c

465 Views Asked by At

I have been assigned to move 10g database to AWS Oracle 12c. Size of data is around 20 GB of actual data but 900 GB has been allocated. So we will need to decrease that. Any suggestions on how to migrate and reduce the size of the database?

1

There are 1 best solutions below

0
On BEST ANSWER

This is a good summary of several options: Importing Data Into Oracle on Amazon RDS

Also here is the Oracle migration Whitepaper.

The solution depends on the size of your data and the accepted downtime.

Personally I used Data Dump in a project, it works well for the size of data you have. I'm not sure about the resizing.