Import Data Using Oracle Data Pump on Autonomous Database
Oracle Data Pump offers very fast bulk data and metadata movement between Oracle databases and Autonomous Databases.
Data Pump Import lets you import data from Data Pump files residing on Oracle Cloud Infrastructure Object Storage, Microsoft Azure, AWS S3, and Oracle Cloud Infrastructure Object Storage Classic. You can save your data to your Cloud Object Store and use Oracle Data Pump to load data to Autonomous Database.
Note
When a load or import operation results in the following timezone related error, you need to upgrade your timezone file to the latest version available for your database:
When a load or import operation results in the following timezone related error, you need to upgrade your timezone file to the latest version available for your database:
ORA-39405: Oracle Data Pump does not support importing from a source database with TSTZ version n+1
into a target database with TSTZ version n.
See Manage Time Zone File Updates on Autonomous Database for more information on this timezone related error.
Topics
- Export Your Existing Oracle Database to Import into Autonomous Database
Use Oracle Data Pump to export your existing Oracle Database as the first step to migrate to Autonomous Database. - Import Data with Oracle Data Pump Latest Version or an Older Version
The steps to import data to Autonomous Database with Oracle Data Pump differ depending on the Oracle Data Pump version. - Access Log Files for Data Pump Import
The log files for Data Pump Import operations are stored in the directory you specify with the data pumpimpdp
directory parameter. - Oracle Data Pump Import and Table Compression
Provides notes for using Oracle Data Pump import on Autonomous Database. - Notes for Importing with Oracle Data Pump
Lists notes for importing with Oracle Data Pump.
Parent topic: Load Data into Autonomous Database