Updating oracle database


03-Jul-2019 13:57

You can use Oracle Data Pump to import complex databases, or databases that are several hundred megabytes or several terabytes in size.

You can also use AWS Database Migration Service (AWS DMS) to import data into an Amazon RDS DB instance.

Oracle Data Pump is a long-term replacement for the Oracle Export/Import utilities and is the preferred way to move large amounts of data from an Oracle installation to an Amazon RDS DB instance.

You can use Oracle Data Pump for several scenarios: To download Oracle Data Pump utilities, go to

AWS DMS can migrate databases without downtime and, for many database engines, continue ongoing replication until you are ready to switch over to the target database.

You can migrate to Oracle from either the same database engine or a different database engine using AWS DMS.

The final step imports the data from the copied dump file into the Amazon RDS Oracle DB instance using the DBMS_DATAPUMP package.

The process has the following requirements: Note This process imports a dump file into the DATA_PUMP_DIR directory, a preconfigured directory on all Oracle DB instances.

Oracle SQL Developer is best suited for migrating small databases.

If you are migrating from a different database engine, you can use the AWS Schema Conversion Tool to migrate schema objects that are not migrated by AWS DMS.