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 is now availble. If you haven't you downloaded already: Why?

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