GV$COPY_CORRUPTION definition in Oracle 9i / www.oracledba.ru
GV$COPY_CORRUPTION
select
inst_id, -- INST_ID NUMBER
ccrid, -- RECID NUMBER
ccstm, -- STAMP NUMBER
ccdcp, -- COPY_RECID NUMBER
ccdcs, -- COPY_STAMP NUMBER
ccdfp, -- FILE# NUMBER
ccblk, -- BLOCK# NUMBER
cccnt, -- BLOCKS NUMBER
to_number (ccscn), -- CORRUPTION_CHANGE# NUMBER
decode -- MARKED_CORRUPT VARCHAR2(3)
(bitand (ccflg, 1), 1, 'YES', 'NO'),
decode -- CORRUPTION_TYPE VARCHAR2(9)
(bitand (ccflg, 30), 2, 'ALL ZERO', 4, 'FRACTURED', 8, 'CHECKSUM', 16, 'CORRUPT', 'LOGICAL')
from
x$kcccc