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. You can also 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: Oracle Cloud Infrastructure Object Storage, Google Cloud Storage, and Wasabi Hot Cloud Storage.

Topics

• Create Credentials and Copy Data into an Existing Table

• Create Credentials and Load Data Pump Dump Files into an Existing Table

• Load JSON Documents with Autonomous Database

• Monitor and Troubleshoot Loads

• List Credentials

• Delete Credentials