Oracle DBMS_CLOUD_ADMIN_INTERNAL
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose Undocumented
AUTHID DEFINER
Dependencies
AUDIT_UNIFIED_ENABLED_POLICIES DBMS_ASSERT DBMS_STANDARD
DBA_EXTENTS DBMS_CLOUD DBMS_SYS_ERROR
DBA_OBJECTS DBMS_CLOUD_CAPABILITY DBMS_SYS_SQL
DBA_REGISTRY DBMS_SERVICE DBMS_UTILITY
DBA_ROLES DBMS_SESSION GV$SESSION
DBA_USERS DBMS_SQL V$PDBS
Documented No
First Available 21c
Security Model Owned by SYS with no privileges granted
Undocumented {ORACLE_HOME}/rdbms/admin/prvt_cloud_admin_int.plb
{ORACLE_HOME}/rdbms/admin/prvt_cloud_admin_int_body.plb
-- prerequisite DBMS_CLOUD_CORE

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.
Source {ORACLE_HOME}/rdbms/admin/prvt_cloud_admin_int.plb
Subprograms
 
CHANGE_CHARACTER_SET (new 21c)
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);
CHANGE_NATIONAL_CHARACTER_SET (new 21c)
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');
DISABLE_APP_CONT (new 21c)
Undocumented dbms_cloud_admin_internal.disable_app_cont(service_name IN VARCHAR2);
exec dbms_cloud_admin_internal.disable_app_cont('PDBDEV');
DV_CHANGE_AUDIT (new 21c)
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);
exec dbms_cloud_admin_internal.dv_change_audit(FALSE);
DV_PRECHECKS (new 21c)
Undocumented dbms_cloud_admin_internal.dv_prechecks(opcode IN NUMBER);
TBD
ENABLE_APP_CONT (new 21c)
Undocumented dbms_cloud_admin_internal.enable_app_cont(service_name IN VARCHAR2);
exec dbms_cloud_admin_internal.enable_app_cont('PDBDEV')
GET_APEX_SCHEMA (new 21c)
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
FROM dual;

GET_APEX_SCHEMA
----------------
 
ROTATE_ENCRYPTION_KEY (new 21c)
Changes the Cloud environment encryption key dbms_cloud_admin_internal.rotate_encryption_key(enc_key IN VARCHAR2);
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_APP_CONT_ADMIN
DBMS_APP_CONT_PRVT
DBMS_APP_CONT_REPORT
Database Vault
DBMS_CLOUD
DBMS_CLOUD_CAPABILITY
DBMS_CLOUD_CORE
DBMS_CLOUD_INTERNAL
DBMS_CLOUD_MACADM
DBMS_CLOUD_REQUEST
DBMS_CLOUD_TASK
DBMS_CLOUD_TYPES
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2021 Daniel A. Morgan All Rights Reserved
  DBSecWorx