7 Using Cloud Storage

Starting from SQLcl release 21.2, you can use the DBMS_CLOUD package for authentication to access objects in Cloud Storage.

The following actions can be performed with either OCI or DBMS_CLOUD:

• Put, get, delete, and peek objects in Cloud Storage.
• Load database objects from objects in Cloud Storage.
• Unload a database table to an object in Cloud Storage.

Table 7-1 Accessing the cloud storage

Using OCI	Using DBMS_CLOUD
Can access on-premises database and cloud database	Can access cloud database only
Set a default Cloud Storage URL, 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
Create an OCI profile for authentication and access as a prerequisite step	Authentication is done using existing OCI or Swift credentials

Use the Cloud Storage (cs) command to set a default Cloud Storage URI, list compartments, buckets and objects, and view some of the contents of an object in Cloud Storage.

Topics

• Using DBMS_CLOUD for Authentication

• Creating the OCI profile for OCI Authentication

• About the Cloud Storage Command Options

• Examples

See Also:

• Loading a File

• Using the OCI Command for Oracle Cloud Infrastructure REST APIs