Autonomous AI Database Supplied Package Reference

This information about the packages you use with Autonomous AI Database. The DBMS_CLOUD topic also covers the DBMS_CLOUD REST APIs.

• Manage Catalogs with DBMS_CATALOG

  The DBMS_CATALOG package provides a comprehensive set of procedures, functions, and types for managing database catalogs for Oracle Autonomous AI Database.

• DBMS_CLOUD Package

  The DBMS_CLOUD package provides database routines for working with cloud resources.

• DBMS_CLOUD_ADMIN Package

  The DBMS_CLOUD_ADMIN package provides administrative routines for configuring a database.

• DBMS_CLOUD_ADMIN_SEC Package

  The DBMS_CLOUD_ADMIN_SEC package provides an API for cloning and synchronizing privileges for the ADMIN user in Autonomous AI Database.

• DBMS_CLOUD_AI Package

  The DBMS_CLOUD_AI package, with Select AI, facilitates and configures the translation of natural language prompts to generate, run, explain SQL statements. Also, enables retrieval augmented generation and natural language-based interactions, including chatting with LLMs.

• DBMS_CLOUD_AI_AGENT Package This package defines and manages Select AI agents, tasks, tools, and orchestration.

• DBMS_CLOUD_FUNCTION Package

  The DBMS_CLOUD_FUNCTION package allows you invoke OCI and AWS Lambda remote functions in your Autonomous AI Database as SQL functions.

• DBMS_CLOUD_FUNCTION_ADMIN Package

  The DBMS_CLOUD_FUNCTION_ADMIN package supports you invoking generic scripts from an Autonomous AI Database instance.

• DBMS_CLOUD_LINK Package The DBMS_CLOUD_LINK package allows a user to register a table or a view as a data set for read only access with Cloud Links.

• DBMS_CLOUD_LINK_ADMIN Package

  The DBMS_CLOUD_LINK_ADMIN package allows the ADMIN user to enable a database user to register data sets or to access registered data sets for a given Autonomous AI Database instance, subject to the access restrictions as defined with the granted scope.

• DBMS_CLOUD_MACADM Package This section covers the DBMS_CLOUD_MACADM subprograms provided with Autonomous AI Database.

• DBMS_CLOUD_MIGRATION Package The DBMS_CLOUD_MIGRATION package facilitates translation of the SQL code from a non-Oracle SQL flavor to Oracle SQL.

• DBMS_CLOUD_NOTIFICATION Package The DBMS_CLOUD_NOTIFICATION package allows you to send messages or the output of a SQL query to a provider.

• DBMS_CLOUD_PIPELINE Package

  The DBMS_CLOUD_PIPELINE package allows you to create data pipelines for loading and exporting data in the cloud. This package supports continuous incremental data load of files in object store into the database. DBMS_CLOUD_PIPELINE also supports continuous incremental export of table data or query results from the database to object store based on a timestamp column.

• DBMS_CLOUD_REPO Package

  The DBMS_CLOUD_REPO package provides for use of and management of cloud hosted code repositories from Oracle AI Database. Supported cloud code repositories include GitHub, AWS CodeCommit , and Azure Repos.

• DBMS_AUTO_PARTITION Package

  The DBMS_AUTO_PARTITION package provides administrative routines for managing automatic partitioning of schemas and tables.

• DBMS_DATA_ACCESS Package

  The DBMS_DATA_ACCESS package provides routines to generate and manage Table Hyperlinks for data sets.

• DBMS_DATA_ACCESS_ADMIN Package The DBMS_DATA_ACCESS_ADMIN package provides administrative routines generate and manage Table Hyperlinks for data sets.

• DBMS_DATA_ACCESS_SCOPE Package The DBMS_DATA_ACCESS_SCOPE package provides routines to register, unregister, update and retrieve creation scope.

• DBMS_DCAT Package The DBMS_DCAT package provides functions and procedures to help Autonomous AI Database users leverage the data discovery and centralized metadata management system of OCI Data Catalog.

• DBMS_INMEMORY_ADMIN Package The DBMS_INMEMORY_ADMIN package enables you to manage the In-Memory area and In-Memory FastStart.

• DBMS_MAX_STRING_SIZE Package The DBMS_MAX_STRING_SIZE package provides an interface for checking and changing the value of the DBMS_MAX_STRING_SIZE initialization parameter.

• DBMS_PIPE Package

  The DBMS_PIPE package lets two or more sessions in the same instance communicate.

• DBMS_PROXY_SQL

  Describes the procedures to enable and disable query offload for an elastic pool leader or an elastic pool member. This package also provides procedures to enable and manage ProxySQL for statement routing.

• DBMS_SHARE Package

  The DBMS_SHARE subprograms and views are used to share local data with external systems.

• CS_RESOURCE_MANAGER Package

  The CS_RESOURCE_MANAGER package provides an interface to create consumer groups, plans, and update consumer group parameters and plan directives.

• CS_SESSION Package

  The CS_SESSION package provides an interface to switch the database service and consumer group of the existing session.

• DBMS_EXT_TABLE_CACHE Package

  The DBMS_EXT_TABLE_CACHE package provides routines to configure and manage caching of frequently accessed data from external tables into Autonomous AI Database.

• DBMS_CACHE Package

  The DBMS_CACHE package facilitates the automatic caching for external table caches in an Autonomous AI Database instance.

• DBMS_MFA_ADMIN Package

  The DBMS_MFA_ADMIN package facilitates and configures the SQL Token Access.

• DBMS_MFA Package

  The DBMS_MFA provides subprograms to request and generate SQL Access Tokens, deliver the MFA challenge through the configured channel, and complete token authorization for the current user or session. These subprograms are used specifically with SQL Access Token MFA to initialize and validate SQL access after the user has connected using their primary authentication method.

• DBMS_CLOUD_IMPORT Package

  DBMS_CLOUD_IMPORT facilitates the import of data from Oracle databases as well as from non-Oracle databases by using the Oracle Heterogeneous Gateway into Autonomous AI Database.