Move Data with Data Pump Export to an Autonomous Database Directory
Oracle Data Pump offers very fast bulk data and metadata movement between Autonomous Database and other Oracle databases. To move data from an Autonomous Database to another Oracle database, use Oracle Data Pump to export to a directory on your Autonomous Database.
This export method is supported on all of the object stores that Autonomous Database supports:
- Oracle Cloud Infrastructure Object Storage
- Oracle Cloud Infrastructure Object Storage Classic
- Azure Blob Storage or Azure Data Lake Storage
- Amazon S3
If you are using Oracle Cloud Infrastructure Object Storage or Oracle Cloud Infrastructure Object Storage Classic, then you can use the alternative methods to export directly to object store. See Move Data with Data Pump Export to Object Store and Move Data to Object Store as Oracle Data Pump Files Using EXPORT_DATA for more information.
This export method includes the following steps:
-
Use Data Pump Export to save a dump file set to a directory on your database.
See Use Data Pump to Create a Dump File Set on Autonomous Database for details.
-
Move the dump file set from the directory on your database to your cloud object store.
See Move Dump File Set from Autonomous Database to Your Cloud Object Store for details.
-
Download the dump file set from the cloud object store, run Data Pump Import, and then perform any required clean up such as removing the dump file set from your cloud object store.
See Download Dump Files, Run Data Pump Import, and Clean Up Object Store for details.
- Use Data Pump to Create a Dump File Set on Autonomous Database
Shows the steps to export data from your Autonomous Database to a directory with Oracle Data Pump. - Move Dump File Set from Autonomous Database to Your Cloud Object Store
To move the dump file set to your Cloud Object Store, upload the files from the database directory to your Cloud Object Store.