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 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 procedureDBMS_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 procedureDBMS_CLOUD.COPY_COLLECTION
provides support for loading JSON documents into SODA collections. The procedureDBMS_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
are logged in the tablesDBMS_CLOUD
dba_load_operations
anduser_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.
Parent topic: Load Data into Autonomous Database