Oracle | POD_CDB_ADMIN

Oracle POD_CDB_ADMIN_COMMON Version 23ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Implements helper APIs that must to be installed as common in an Autonomous Database

The source for the two known dependent objects could not be found so a valid deployment of this package was not possible.

AUTHID DEFINER

Dependencies

POD_CDB_ADMIN_JOB

Documented No

Exceptions

Error Code	Reason
N/A	Operation_timeout exception

First Available Not known

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/pod_cdb_admin_common_spec.sql
{ORACLE_HOME}/rdbms/admin/pod_cdb_admin_common.plb

SQL> @?/rdbms/admin/pod_cdb_admin_common_spec.sql

      

      SP2-0808: Package created with compilation warnings

      

      SQL> sho err

      Errors for PACKAGE POD_CDB_ADMIN_COMMON:

      

      LINE/COL ERROR

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

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

      clause; default value DEFINER used

      

      19/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY

      compiler hint

      

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

Subprograms

PDB_CLOSE_TRIGGER_TASKS

PDB_OPEN_TRIGGER_TASKS

SHRINK_DATABASE

PDB_CLOSE_TRIGGER_TASKS

List of tasks for PDB close pod_cdb_admin_common.pdb_close_trigger_tasks;

exec pod_cdb_admin_common.pdb_close_trigger_tasks;

PDB_OPEN_TRIGGER_TASKS

List of tasks for PDB open pod_cdb_admin_common.pdb_open_trigger_tasks;

exec pod_cdb_admin_common.pdb_open_trigger_tasks;

SHRINK_DATABASE

Undocumented pod_cdb_admin.shrink_database( max_size IN VARCHAR2, -- intended maxsize after shrink status OUT CLOB); -- status from running the shrink operation

TBD