V$COPY_CORRUPTION definition in Oracle Database 11.2
V$COPY_CORRUPTION

select
  RECID,                                   -- RECID NUMBER
  STAMP,                                   -- STAMP NUMBER
  COPY_RECID,                              -- COPY_RECID NUMBER
  COPY_STAMP,                              -- COPY_STAMP NUMBER
  FILE#,                                   -- FILE# NUMBER
  BLOCK#,                                  -- BLOCK# NUMBER
  BLOCKS,                                  -- BLOCKS NUMBER
  CORRUPTION_CHANGE#,                      -- CORRUPTION_CHANGE# NUMBER
  MARKED_CORRUPT,                          -- MARKED_CORRUPT VARCHAR2(3)
  CORRUPTION_TYPE                          -- CORRUPTION_TYPE VARCHAR2(9)
from
  GV$COPY_CORRUPTION
where
  inst_id = USERENV('Instance')

home |  up