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.

The package DBMS_CLOUD supports loading files from the following cloud services:

• Oracle Cloud Infrastructure Object Storage

• Azure Blob Storage

• Amazon S3

• Amazon S3-Compatible, including: Wasabi Hot Cloud Storage

• GitHub Repository

• Google Cloud Storage

See DBMS_CLOUD Package File URI Formats for more information.

• Create Credentials and Copy Data into an Existing Table
  For data loading from files in the Cloud, you need to first store your object storage credentials in your Autonomous Database and then use the procedure DBMS_CLOUD.COPY_DATA to load data.
• Create Credentials and Load Data Pump Dump Files into an Existing Table
  For data loading you can also use Oracle Data Pump dump files as source files.
• Load JSON on Autonomous Database
  The PL/SQL procedure DBMS_CLOUD.COPY_COLLECTION provides support for loading JSON documents into SODA collections. The procedure DBMS_CLOUD.COPY_DATA provides support for loading JSON data into an existing table in Autonomous Database.
• Monitor and Troubleshoot Loads
  All data load operations done using the PL/SQL package DBMS_CLOUD are logged in the tables dba_load_operations and user_load_operations:
• Examples for Loading Data into Autonomous Database
  Provides examples for loading data in various formats and from different Cloud Storage providers into Autonomous Database.