Oracle provides several options to move data into an Autonomous Database. Learn about the different data migration and loading options supported by Autonomous Database.
- Migrate Data into Autonomous Database on Dedicated Exadata Infrastructure
Data migration is moving data with or without its schema from one system, location, or application to another. One classic example of data migration is when you decide to adopt Autonomous Database for your organization and move the existing historical data from the current database to Autonomous Database.
- Loading Data into Autonomous Database on Dedicated Exadata Infrastructure
You can bulk load data into Autonomous Database on Dedicated Exadata Infrastructure using Oracle Database tools, and Oracle or other 3rd party data integration tools.
- Load Data from Files in the Cloud
The PL/SQL package
DBMS_CLOUD provides support for loading data from files in the cloud to tables created in your Autonomous Database on Dedicated Exadata Infrastructure.
- Use Oracle Data Pump
Oracle Data Pump offers very fast bulk data and metadata movement between Oracle databases and Autonomous Database on Dedicated Exadata Infrastructure.
- Use SQL*Loader
You can use Oracle SQL*Loader to load data from local files in your client machine into Autonomous Database on Dedicated Exadata Infrastructure.
- Migrate to Autonomous Database Using Oracle Database Migration Service
You can migrate data to an Autonomous Database using Oracle Cloud Infrastructure Database Migration Service that is a fully managed cloud service created to ease the move of established databases from on-premise, third-party, or on Oracle Cloud to Autonomous Database.
- Use Oracle GoldenGate to Replicate Data with Autonomous Database
You can replicate data to Autonomous Database using Oracle GoldenGate and Oracle GoldenGate Cloud Service. You can capture changes from the Autonomous Database and replicate to any target database or platform that Oracle GoldenGate supports, including other Autonomous Database on Dedicated Exadata Infrastructures.