8 Using Cloud Storage

SQLcl supports Oracle Cloud Infrastructure (OCI) Object Storage for loading, unloading, and managing objects in Cloud Storage.

You can authenticate using either:

• An OCI profile, which supports both on-premises and Oracle Cloud databases.

• A DBMS_CLOUD credential, which is available for Oracle Cloud databases.

The following operations are supported with both authentication methods:

• Upload, download, preview, and delete objects in Cloud Storage.
• Load database objects from Cloud Storage.
• Unload database tables to Cloud Storage.

Table 8-1 Accessing cloud storage

Using OCI	Using DBMS_CLOUD
Can access on-premises database and cloud database.	Can access cloud database only.
List compartments, buckets and objects, and view some of the contents of an object in Cloud Storage.	Set a default Cloud Storage URL, list objects, and view some of the contents of an object in Cloud Storage.
Require an OCI profile for authentication and access as a prerequisite step.	Authentication is done using existing OCI or Swift credentials.

Topics

• Using DBMS_CLOUD Authentication

• Configuring Cloud Storage

• Using the Cloud Storage Command

• Examples

See Also:

• Loading a File

• Using the OCI Command for Oracle Cloud Infrastructure REST APIs