1. Utilities
  2. Other Utilities
  3. DBMS_CLOUD Family of Packages
  4. Using the DBMS_CLOUD Family of Packages

20.1 Using the DBMS_CLOUD Family of Packages

Learn about the requirements for deploying and using the DBMS_CLOUD family of packages.

The DBMS_CLOUD packages are preinstalled, configured, and maintained in Oracle Autonomous Database. However, to use the DBMS_CLOUD packages on a customer-managed Oracle Database, you must perform manual installation and configuration procedures. In comparison to the use of DBMS_CLOUD packages in Oracle Autonomous Database, these packages can offer only a subset of functionality available in Oracle Autonomous Database as a fully managed Cloud-native Oracle Database service with components beyond the core database.

Note:

For customer-managed, non-Autonomous Database uses of DBMS_CLOUD, see the documentation for the Oracle Database release. The installation in Oracle Database 19c, Oracle Database 21c, and earlier releases of Oracle Database 23ai is different than the processes for Oracle Database 23ai Release update 7 and later. For information about using DBMS_CLOUD with earlier releases, see How To Setup And Use DBMS_CLOUD Package (Doc ID 2748362.1)

DBMS_CLOUD Packages

The DBMS_CLOUD family of packages consists of the following:

  • DBMS_CLOUD
  • DBMS_CLOUD_AI
  • DBMS_CLOUD_NOTIFICATION
  • DBMS_CLOUD_PIPELINE
  • DBMS_CLOUD_REPO

Overview of Installation and Configuration Steps

To set up DBMS_CLOUD, the following installation and configuration steps must be completed:

Installing and configuring DBMS_CLOUD:

  • Create a schema owning the DBMS_CLOUD package, and install the DBMS_CLOUD code in the container database (CDB), and all pluggable databases (PDBs).
  • Create a wallet to contain the certificates required to access HTTP URIs and Object Stores.
  • Configure your Oracle Database environment to use the new SSL wallet.
  • Configure your database with access control lists (ACLs) for DBMS_CLOUD.
  • Verify the configuration of DBMS_CLOUD.

Configuring users or roles to use DBMS_CLOUD:

  • Grant the minimal privileges to a user or role for using DBMS_CLOUD
  • Configure ACLs for a user or role to use DBMS_CLOUD
  • Verify the proper setup of your user or role for using DBMS_CLOUD

Related Topics

Parent topic: DBMS_CLOUD Family of Packages