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 or Azure Data Lake Storage
-
Amazon S3
-
Amazon S3-Compatible, including: Wasabi Hot Cloud Storage
-
GitHub Repository
-
Google Cloud Storage
See DBMS_CLOUD URI Formats for more information.