DBA Data[Home] [Help]

VIEW: SYS.V_$OFFLINE_RANGE

Source

View Text - Preformatted

select "RECID","STAMP","FILE#","OFFLINE_CHANGE#","ONLINE_CHANGE#","ONLINE_TIME","RESETLOGS_CHANGE#","RESETLOGS_TIME","CON_ID" from v$offline_range
View Text - HTML Formatted

SELECT "RECID"
, "STAMP"
, "FILE#"
, "OFFLINE_CHANGE#"
, "ONLINE_CHANGE#"
, "ONLINE_TIME"
, "RESETLOGS_CHANGE#"
, "RESETLOGS_TIME"
, "CON_ID"
FROM V$OFFLINE_RANGE