DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.CDB_ROLLING_PLAN

Object Details
Object Name: CDB_ROLLING_PLAN
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

List of instructions which constitutes the upgrade plan in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
REVISION NUMBER

Plan revision number associated with an instruction
BATCHID NUMBER

Identifier for a batch of instructions which are requested together
INSTID NUMBER

Identifier for a single instruction
SOURCE VARCHAR2 (128)
Database unique name where an instruction is initiated
TARGET VARCHAR2 (128)
Database unique name where an instruction executes
PHASE VARCHAR2 (14)
Rolling upgrade phase in which an instruction executes
STATUS VARCHAR2 (7)
Scheduling status of the instruction
PROGRESS VARCHAR2 (10)
Execution Progress of the instruction
DESCRIPTION VARCHAR2 (256)
Description of the instruction
EXEC_STATUS NUMBER

Status code returned from instruction execution
EXEC_INFO VARCHAR2 (256)
Supplemental information obtained during instruction execution
EXEC_TIME TIMESTAMP(6) (11)
Time of instruction execution
FINISH_TIME TIMESTAMP(6) (11)
Time of instruction completion
CON_ID NUMBER

container id
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT REVISION
,      BATCHID
,      INSTID
,      SOURCE
,      TARGET
,      PHASE
,      STATUS
,      PROGRESS
,      DESCRIPTION
,      EXEC_STATUS
,      EXEC_INFO
,      EXEC_TIME
,      FINISH_TIME
,      CON_ID
FROM SYS.CDB_ROLLING_PLAN;

Dependencies

[top of page]

SYS.CDB_ROLLING_PLAN does not reference any database object

SYS.CDB_ROLLING_PLAN is referenced by following:

SchemaPUBLIC
SynonymCDB_ROLLING_PLAN