I dug a little more and found my answer. I found that Oracle uses DBMS_REPAIR just to put a band-aid on the corrupt blocks. It basically identifies the corrupt block and marks it so oracle skips over it like it's not even there.
-----Original Message-----
From: Stefick Ronald S Contr ESC/HRIDD
Sent: Thursday, July 17, 2003 8:55 AM
To: Multiple recipients of list ORACLE-L
Subject: DBMS_REPAIR PackageHas anyone ever used DBMS_REPAIR? If so, what do you think of it, does the DB have to be shutdown to run it. Does it really fix any corrupt blocks in the datafiles? We ran DBVerify and found several corrupt DB files in one of our DB's.
TIA,
Scott Stefick
MILPDS OCP Oracle DBA
[EMAIL PROTECTED]
210-565-2540
