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 (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;
/

Related Topics
Built-in Functions
Built-in Packages
Database Security
Autonomous Database
POD_CDB_ADMIN
POD_CDB_ADMIN_HTTP
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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx