Move Data with Data Pump Export to Object Store
To move data from Autonomous Databases to other Oracle databases you can use Oracle Data Pump. Using this export method you use Oracle Data Pump to directly export data to your object store. This export method is supported with Oracle Cloud Infrastructure Object Storage and Oracle Cloud Infrastructure Object Storage Classic.
See Move Data with Data Pump Export to an Autonomous Database Directory for details on the alternative export method to use with other supported cloud object stores.
To export data from Autonomous Databases to other Oracle databases, do the following:
-
Use Data Pump Export to export from your database to Object Storage.
You have two options for setting the credential to access Object Store, depending on your Oracle Data Pump version:
-
Using Oracle Data Pump version 19.9 (or later) use the
CREDENTIAL
parameter to set the credential or set the database propertyDEFAULT_CREDENTIAL
, both options are supported. See Use Oracle Data Pump to Export Data to Object Store Using CREDENTIAL Parameter (Version 19.9 or Later) for details. -
For Oracle Data Pump versions before 19.9 the
CREDENTIAL
parameter is not supported. Use theDEFAULT_CREDENTIAL
database property to set the credential to use to access your Object Store. See Use Oracle Data Pump to Export Data to Object Store Setting DEFAULT_CREDENTIAL Property for details.
-
-
Download the dump files from the Object Storage service, run Data Pump Import with the dump files, and perform any required clean up such as removing the dump file set from Object Storage.
See Download Dump Files, Run Data Pump Import, and Clean Up Object Store for details.
- Use Oracle Data Pump to Export Data to Object Store Using CREDENTIAL Parameter (Version 19.9 or Later)
Shows the steps to export data from your database to Object Storage with Oracle Data Pump. - Use Oracle Data Pump to Export Data to Object Store Setting DEFAULT_CREDENTIAL Property
Shows the steps to export data from your database to Object Storage with Oracle Data Pump.