8.2 Configuring Cloud Storage

Cloud Storage configuration is managed through the set cloudstorage and show cloudstorage commands.

You can configure:

Command Description
set/show cloudstorage uri Sets or shows the default Cloud Storage URI.
set/show cloudstorage transfer Sets or displays the transfer method (OCI or DBMS_CLOUD).
set/show cloudstorage credential Sets or displays the DBMS_CLOUD credential.
show cloudstorage profile Displays the current OCI profile.

Note:

PROFILE is display-only. Cloud Storage operations automatically use the current OCI profile selected for the session. Cloud Storage does not maintain a separate profile setting. To view the active profile, use show cloudstorage profile.

For more information about the set/show cloudstorage commands, see the inline SQLcl help.

Examples
set cloudstorage uri https://objectstorage...
set cloudstorage transfer oci
set cloudstorage transfer dbms_cloud
set cloudstorage credential my_credential
show cloudstorage