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
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
|
|
|