DBA Data[Home] [Help]

VIEW: SYS.GV_$COPY_CORRUPTION

Source

View Text - Preformatted

select "INST_ID","RECID","STAMP","COPY_RECID","COPY_STAMP","FILE#","BLOCK#","BLOCKS","CORRUPTION_CHANGE#","MARKED_CORRUPT","CORRUPTION_TYPE","CON_ID" from gv$copy_corruption
View Text - HTML Formatted

SELECT "INST_ID"
, "RECID"
, "STAMP"
, "COPY_RECID"
, "COPY_STAMP"
, "FILE#"
, "BLOCK#"
, "BLOCKS"
, "CORRUPTION_CHANGE#"
, "MARKED_CORRUPT"
, "CORRUPTION_TYPE"
, "CON_ID"
FROM GV$COPY_CORRUPTION