Load Data into Autonomous Database

Describes packages and tools to load data with Autonomous Database.

• About Data Loading
  Autonomous Database provides many different options to load data into your database.
• Load Data with Oracle Database Actions
  Oracle Database Actions provides a web-based interface with development tools, data tool, administration, and monitoring features and lets you load or access data from local files, from cloud storage, or from remote databases.
• Load Data from Files in the Cloud
  The PL/SQL package DBMS_CLOUD provides support for loading data from text, ORC, Parquet, and Avro files in the Cloud to your tables in Autonomous Database. In addition, using DBMS_CLOUD you can load Data Pump dump files in the Cloud to your tables in Autonomous Database.
• 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.
• Load Data from Local Files with Oracle Database Actions
  Using Oracle Database Actions, from the Worksheet page, you can load data from local files into an existing table.
• Load Data or Query Data from Files in a Directory
  You can use DBMS_CLOUD procedures to load data from files in a directory, including directories created on attached network file systems. You can also use these procedures to create external tables that you can use to query data.
• Load Data from Local Files Using SQL*Loader
  Instead of using SQL*Loader Oracle recommends loading data from the Cloud Object Storage for better performance and enhanced functionality.
• Using Data Pipelines for Continuous Load and Export
  Data pipelines allow you to repeatedly load data from object store or export data to object store. Load pipelines provide continuous incremental data loading from external sources (as data arrives on object store it is loaded to a database table). Export pipelines provide continuous incremental data exporting to object store (as new data appears in a database table it is exported to object store).
• The Data Load Page
  Use the Data Load page to make more data available to your Oracle Autonomous Database. You can load data from files or databases, from links to external databases or cloud storage files, or from a live feed of data from cloud storage.
• Transform Data Using Data Studio
  Data Transforms is an easy-to-use graphical user interface that you can use to design graphical data transformations for data integration with Autonomous Database.
• View Data Pump Jobs and Import Data with Data Pump
  Use the Data Pump page to view Data Pump jobs and use the wizard to quickly create and run Data Pump import jobs.