6 Moving Data from Autonomous Transaction Processing to Other Oracle Databases

Oracle Data Pump offers very fast bulk data and metadata movement between Autonomous Transaction Processing and other Oracle databases.

To export data and move the data from Autonomous Transaction Processing to other Oracle databases, do the following:

  1. Use Data Pump Export to export to a directory on Autonomous Transaction Processing.
  2. Move the dump file set from the directory on Autonomous Transaction Processing to your Cloud Object Store.
  3. Depending on the target database you may need to download the dump files from the Cloud Object Store.
  4. Run Data Pump Import with the dump files.
  5. Perform any required clean up such as removing the dump file set from Cloud Object Store.