V$RESTORE_POINT definition in Oracle Database 11.2

V$RESTORE_POINT

select
  SCN,                                     -- SCN NUMBER
  DATABASE_INCARNATION#,                   -- DATABASE_INCARNATION# NUMBER
  GUARANTEE_FLASHBACK_DATABASE,            -- GUARANTEE_FLASHBACK_DATABASE VARCHAR2(3)
  STORAGE_SIZE,                            -- STORAGE_SIZE NUMBER
  TIME,                                    -- TIME TIMESTAMP(9)
  RESTORE_POINT_TIME,                      -- RESTORE_POINT_TIME TIMESTAMP(9)
  PRESERVED,                               -- PRESERVED VARCHAR2(3)
  NAME                                     -- NAME VARCHAR2(128)
from
  GV$RESTORE_POINT
where
  inst_id = USERENV('Instance')

home | up