ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com. Request a Workshop for
your organization today.
Purpose
Maintenance Plan Utilities. The objects in this package are used used to set/update/delete maintenance plans in CDB$ROOT by user with the EXECUTE_CATALOG_ROLE role.
A maintenance plan can be queried in a PDB via the DB_NOTIFICATIONS view by a user that has the SELECT_CATALOG_ROLE system privilege or the MAINTPLAN_APP system privilege.
AUTHID
CURRENT_USER
Constants
Name
Data Type
Value
General: Section 1
ACTUAL_ENDTM
VARCHAR2(64)
'actualEndDate'
ACTUAL_STARTM
VARCHAR2(64)
'actualStartDate'
ADDITIONALDATA
VARCHAR2(64)
'additionalData'
DBID
VARCHAR2(64)
'DBID'
DB_UNIQUE_NAME
VARCHAR2(128)
'DB_UNIQUE_NAME'
EXPECTED_ENDTM
VARCHAR2(64)
'expectedEndDate'
EXPECTED_STARTM
VARCHAR2(64)
'expectedStartDate'
INSTANCES
VARCHAR2(64)
'instances'
MAINT_DESC
VARCHAR2(64)
'description'
MAINT_PRODUCT
VARCHAR2(64)
'maintenanceProduct'
MAINT_STATUS
VARCHAR2(64)
'maintenanceStatus'
MAINT_TYPE
VARCHAR2(64)
'maintenanceType'
PATCHID
VARCHAR2(64)
'patchID'
PDBS
VARCHAR2(64)
'pdbs'
PLAN_JSON_DOC
VARCHAR2(64)
'planJsonDoc'
UPDATE_TYPE
VARCHAR2(64)
'updateType'
General: Section 2
NOTIFICATION_TIME
VARCHAR2(64)
'notificationTime'
NOTIFICATION_TYPE
VARCHAR2(64)
'notificationType'
STATUS
VARCHAR2(64)
'status'
General: Section 3
DEFAULT_DATEFORMAT
VARCHAR2(64)
'MM/DD/YYYY HH24:MI:SS TZH:TZM'
General: Section 4
STATUS_PENDING
NUMBER
1
STATUS_RESOLVED
NUMBER
2
STATUS_OBSOLETE
NUMBER
3
Data Types
SQL> desc plan_params
Name Type
----------------- -------------
NOTIFICATION_TYPE VARCHAR2(64)
NOTIFICATION_TIME VARCHAR2(64)
STATUS VARCHAR2(64)
PLANJSONTYPE CHAR(1)
PLANJSONDOC CLOB
METHOD
------
FINAL CONSTRUCTOR FUNCTION PLAN_PARAMS RETURNS SELF AS RESULT
METHOD
------
MEMBER PROCEDURE SET_PARAM
Argument Name Type In/Out
------------------------------ ----------------------- ------
PARAM VARCHAR2 IN
PARAM_VAL VARCHAR2 IN
METHOD
------
MEMBER FUNCTION GET_PARAM RETURNS VARCHAR2
Argument Name Type In/Out
------------------------------ ----------------------- ------
PARAM VARCHAR2 IN
Dependencies
DB_NOTIFICATIONS
DBMS_SYS_ERROR
MAINTPLAN_SEQ
DBMS_OUTPUT
JSON_ELEMENT_T
PLAN_PARAMS
DBMS_SQL
JSON_OBJECT_T
PLITBLM
Documented
No
First Available
20c
Security Model
Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role
Related privileges include SELECT_CATALOG_ROLE and the MAINTPLAN_APP system privilege.