RE: Data Block Corruption

What version of the database? There is a tool for block editing that is supposedly only for internal use that was shipped with most releases before 9 I believe. Usual caveat - don't do this on your Production database. :-)  

More to the point, though, is there really a need to do it? After all, IIRC all that you can do with DBMS_REPAIR is mark the block software corrupt so that Oracle will skip it. You can't actually repair the block.  

The other alternative to bbed is to run a large magnet over your disk, or alternatively drill a hole through the platters! :-)  

Pete  

"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook  

"Oh no it's not. It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA.  

-----Original Message-----
Sent: Tuesday, April 29, 2003 8:57 AM
To: Multiple recipients of list ORACLE-L  

Hello all,  

I wanted to test recovery procedure for data block corruption using DBMS_REPAIR package.
To test this I need a database object with a corrupt block. How can I corrupt a data block in
a table?  

TIA
Ashish

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pete Sharman
  INET: peter.sharman_at_oracle.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).