Oracle | DBMS_CLOUD_ADMIN

Oracle DBMS_CLOUD_ADMIN_INTERNAL Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Internal administrative procedures for actions in the Oracle Autonomous Cloud Database environment.

AUTHID DEFINER

Dependencies (not based on Autonomous Database)

AUDIT_UNIFIED_ENABLED_POLICIES	DBMS_CLOUD_ADMIN	DBMS_SYS_ERROR
DBA_EXTENTS	DBMS_CLOUD_CORE	DBMS_SYS_SQL
DBA_OBJECTS	DBMS_CLOUD_INTERNAL	DBMS_UTILITY
DBA_REGISTRY	DBMS_CLOUD_MACADM	GV$SESSION
DBA_ROLES	DBMS_DB_VERSION	JSON_ELEMENT_T
DBA_USERS	DBMS_SERVICE	JSON_OBJECT_T
DBMS_ASSERT	DBMS_SQL	V$PDBS
DBMS_CLOUD	DBMS_STANDARD

Documented No

Exceptions

Error Code	Reason
ORA-20998	CHANGE CHARACTER SET capability is not enabled

First Available 21c

Package Deployment {ORACLE_HOME}/rdbms/admin/prvt_cloud_admin_int.plb
{ORACLE_HOME}/rdbms/admin/prvt_cloud_admin_int_body.plb

-- prerequisites

      {ORACLE_HOME}/rdbms/admin/dbms_cloud_task_catalog.sql

      {ORACLE_HOME}/rdbms/admin/dbms_cloud_task_views.sql

      {ORACLE_HOME}/rdbms/admin/prvt_cloud_body.plb

      

      SQL> @?/rdbms/admin/prvt_cloud_admin_int.plb

      

      Session altered.

      

      SP2-0808: Package created with compilation warnings

      

      Errors for PACKAGE DBMS_CLOUD_ADMIN_INTERNAL:

      

      LINE/COL ERROR

      ------------------------------------------------------------------------

      1/1 PLW-05018: unit DBMS_CLOUD_ADMIN_INTERNAL omitted optional AUTHID

      clause; default value DEFINER used

      

      67/9 PLW-06010: keyword "NAME" used as a defined name

      68/9 PLW-06010: keyword "FORCE" used as a defined name

      92/9 PLW-06010: keyword "NAME" used as a defined name

      93/9 PLW-06010: keyword "FORCE" used as a defined name

      

      Session altered.

      

      SQL> @?/rdbms/admin/prvt_cloud_admin_int_body.plb

      

      Session altered.

      

      SP2-0810: Package Body created with compilation warnings

      

      Errors for PACKAGE BODY DBMS_CLOUD_ADMIN_INTERNAL:

      

      LINE/COL ERROR

      -------- -----------------------------------------------------------------

      191/5 PLW-07206: analysis suggests that the assignment to 'L_CUR' may be unnecessary

      

      207/9 PLW-06010: keyword "TYPE" used as a defined name

      248/3 PLW-05005: subprogram GET_CHARSET_TYPE_STR returns without value at line 276

      

      249/9 PLW-06010: keyword "TYPE" used as a defined name

      283/9 PLW-06010: keyword "NAME" used as a defined name

      284/9 PLW-06010: keyword "TYPE" used as a defined name

      285/9 PLW-06010: keyword "FORCE" used as a defined name

      347/22 PLW-07204: conversion away from column type may result in sub-optimal query plan

      

      431/14 PLW-06009: procedure "KILL_SESSIONS" OTHERS handler does not end in RAISE

      

      448/9 PLW-06010: keyword "TYPE" used as a defined name

      574/9 PLW-06010: keyword "NAME" used as a defined name

      575/9 PLW-06010: keyword "TYPE" used as a defined name

      576/9 PLW-06010: keyword "FORCE" used as a defined name

      638/14 PLW-06009: procedure "CHANGE_CHARACTER_SET_INT" OTHERS handler does not end in RAISE

      

      776/9 PLW-06010: keyword "NAME" used as a defined name

      777/9 PLW-06010: keyword "FORCE" used as a defined name

      794/9 PLW-06010: keyword "NAME" used as a defined name

      795/9 PLW-06010: keyword "FORCE" used as a defined name

      

      Session altered.

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvt_cloud_admin_int.plb

Subprograms

CHANGE_CHARACTER_SET	ENABLE_APP_CONT
CHANGE_NATIONAL_CHARACTER_SET	GET_APEX_SCHEMA
DISABLE_APP_CONT	GET_ENCRYPTION_KEY_INFO
DV_CHANGE_AUDIT	ROTATE_ENCRYPTION_KEY
DV_PRECHECKS	RUN_STMT

CHANGE_CHARACTER_SET

Changes the database's character set dbms_cloud_admin_internal.change_character_set( name IN VARCHAR2, force IN BOOLEAN);

SELECT parameter, value

      FROM v$nls_parameters

      WHERE parameter LIKE '%LANG%'

      ORDER BY 1;

      

      PARAMETER          VALUE

      ------------------ ---------

      NLS_DATE_LANGUAGE  AMERICAN

      NLS_LANGUAGE       AMERICAN

      

      exec dbms_cloud_admin_internal.change_character_set('AMERICAN', FALSE);

      

      PL/SQL procedure successfully completed.

CHANGE_NATIONAL_CHARACTER_SET

Changes the database's national character set dbms_cloud_admin_internal.change_national_character_set( name IN VARCHAR2, force IN BOOLEAN);

exec dbms_cloud_admin_internal.change_national_character_set('AL16UTF16', FALSE);

      *

      ORA-20998: CHANGE CHARACTER SET is not enabled

DISABLE_APP_CONT

Disable Application Continuity dbms_cloud_admin_internal.disable_app_cont(service_name IN VARCHAR2);

exec dbms_cloud_admin_internal.disable_app_cont('PDBDEV');

      

      PL/SQL procedure successfully completed.

DV_CHANGE_AUDIT

Enables or Disables Data base Vault Auditing dbms_cloud_admin_internal.dv_change_audit(enable IN BOOLEAN);

exec dbms_cloud_admin_internal.dv_change_audit(TRUE);

      

      PL/SQL procedure successfully completed.

      

      exec dbms_cloud_admin_internal.dv_change_audit(FALSE);

      

      PL/SQL procedure successfully completed.

DV_PRECHECKS

Undocumented dbms_cloud_admin_internal.dv_prechecks(opcode IN NUMBER);

TBD

ENABLE_APP_CONT

Enable Application Continuity dbms_cloud_admin_internal.enable_app_cont(service_name IN VARCHAR2);

exec dbms_cloud_admin_internal.enable_app_cont('PDBDEV');

      

      PL/SQL procedure successfully completed.

GET_APEX_SCHEMA

Returns the name of an installed APEX schema, else NULL dbms_cloud_admin_internal.get_apex_schema RETURN VARCHAR2;

SELECT dbms_cloud_admin_internal.get_apex_schema;

      

      GET_APEX_SCHEMA

      ----------------

GET_ENCRYPTION_KEY_INFO (new 23ai)

Undocumented dbms_cloud_admin_internal.get_encryption_key_info RETURN json_object_t;

DECLARE

       retVal sys.json_object_t;

      BEGIN

        retVal := dbms_cloud_admin_internal.get_encryption_key_info;

      END;

      /


      PL/SQL procedure successfully completed.

ROTATE_ENCRYPTION_KEY

Changes the Cloud environment encryption key dbms_cloud_admin_internal.rotate_encryption_key(enc_key IN VARCHAR2);

TBD

RUN_STMT (new 23ai)

Undocumented dbms_cloud_admin_internal.run_stmt( stmt IN VARCHAR2, userid IN NUMBER, parse_only IN BOOLEAN);

TBD