Oracle | POD_CDB_ADMIN

Oracle POD_CDB_ADMIN_COMMON 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 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

Standard (Only)

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

Subprograms

PDB_CLOSE_TRIGGER_TASKS

PDB_OPEN_TRIGGER_TASKS

SHRINK_DATABASE

PDB_CLOSE_TRIGGER_TASKS (new 21c)

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 (new 21c)

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 (new 21c)

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

DECLARE

       outVal CLOB;

      BEGIN

        pod_cdb_admin_common.shrink_database('???' outVal);

        dbms_output.put_line(outVal);

      END;

      /