DBA Data[Home] [Help]

VIEW: SYS.V_$DATABASE_INCARNATION

Source

View Text - Preformatted

select "INCARNATION#","RESETLOGS_CHANGE#","RESETLOGS_TIME","PRIOR_RESETLOGS_CHANGE#","PRIOR_RESETLOGS_TIME","STATUS","RESETLOGS_ID","PRIOR_INCARNATION#","FLASHBACK_DATABASE_ALLOWED","CON_ID" from
   v$database_incarnation
View Text - HTML Formatted

SELECT "INCARNATION#"
, "RESETLOGS_CHANGE#"
, "RESETLOGS_TIME"
, "PRIOR_RESETLOGS_CHANGE#"
, "PRIOR_RESETLOGS_TIME"
, "STATUS"
, "RESETLOGS_ID"
, "PRIOR_INCARNATION#"
, "FLASHBACK_DATABASE_ALLOWED"
, "CON_ID" FROM V$DATABASE_INCARNATION