Thursday, May 19, 2011

CORRUPTED BLOCK DETECTION

CORRUPTED BLOCK DETECTION
-----------------------------------------------------

SELECT OBJECT_NAME, BLOCK_ID, CORRUPT_TYPE, MARKED_CORRUPT,
CORRUPT_DESCRIPTION, REPAIR_DESCRIPTION
FROM REPAIR_TABLE WHERE BLOCK_ID=;

SQL> DESC V$DATABASE_BLOCK_CORRUPTION;

No comments: