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