Oracle-L: RE: Data Block Corruption

From: Johnson, Michael <Michael.Johnson_at_oln-afmc.af.mil>
Date: Tue, 29 Apr 2003 13:37:09 -0800
Message-ID: <F001.0058C46D.20030429133709@fatcity.com>

If you want to get real obnoxious, just vi the physical datafile where the tablespace
resides and edit one area of the file by putting some characters in there and then
save and exit. Of Course, Dont forget to backup your files before doing all of this.

-----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: Johnson, Michael
INET: Michael.Johnson_at_oln-afmc.af.mil

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). Received on Tue Apr 29 2003 - 16:37:09 CDT