DBA Data[Home] [Help]

VIEW: SYS.DBA_REGISTRY_LOG

Source

View Text - Preformatted

SELECT optime,
       namespace, cid,
       DECODE(operation,-1, 'START',
                         0, 'INVALID',
                         1, 'VALID',
                         2, 'LOADING',
                         3, 'LOADED',
                         4, 'UPGRADING',
                         5, 'UPGRADED',
                         6, 'DOWNGRADING',
                         7, 'DOWNGRADED',
                         8, 'REMOVING',
                         9, 'OPTION OFF',
                         10, 'NO SCRIPT',
                         99, 'REMOVED',
                         100, 'ERROR',
                         NULL),
       errmsg
FROM registry$log
View Text - HTML Formatted

SELECT OPTIME
, NAMESPACE
, CID
, DECODE(OPERATION
, -1
, 'START'
, 0
, 'INVALID'
, 1
, 'VALID'
, 2
, 'LOADING'
, 3
, 'LOADED'
, 4
, 'UPGRADING'
, 5
, 'UPGRADED'
, 6
, 'DOWNGRADING'
, 7
, 'DOWNGRADED'
, 8
, 'REMOVING'
, 9
, 'OPTION OFF'
, 10
, 'NO SCRIPT'
, 99
, 'REMOVED'
, 100
, 'ERROR'
, NULL)
, ERRMSG FROM REGISTRY$LOG