How do I corrupt a block
hi, This may sound funny. I want to know how to corrupt a block. I want to test the different methods of identifying block corruption, but I don't have sample data blocks. Please help me novice
Re: How do I corrupt a block
Hi ! The simple thing is you can edit the datablocks using BBED editor. It is shipped with Oracle and You need a password to use that utility. You can browse and edit the data blocks. $BBED will give the required details. BUT IT IS DANGEROUS --- novicedba [EMAIL PROTECTED] wrote: hi, This may sound funny. I want to know how to corrupt a block. I want to test the different methods of identifying block corruption, but I don't have sample data blocks. Please help me novice = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: How do I corrupt a block
It apparently is only on NT, and unless you have the password, which is known only to Oracle Support Personnel, you can't use it. http://www.ixora.com.au/q+a/0101/23224038.htm Jared On Thursday 31 May 2001 12:10, K Gopalakrishnan wrote: Hi ! The simple thing is you can edit the datablocks using BBED editor. It is shipped with Oracle and You need a password to use that utility. You can browse and edit the data blocks. $BBED will give the required details. BUT IT IS DANGEROUS --- novicedba [EMAIL PROTECTED] wrote: hi, This may sound funny. I want to know how to corrupt a block. I want to test the different methods of identifying block corruption, but I don't have sample data blocks. Please help me novice = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: How do I corrupt a block
Do a "dd" on unix and changethe contents of any particular block. -Original Message-From: novicedba [mailto:[EMAIL PROTECTED]]Sent: Thursday, May 31, 2001 2:16 PMTo: Multiple recipients of list ORACLE-LSubject: How do I corrupt a block hi, This may sound funny. I want to know how to corrupt a block. I want to test the different methods of identifying block corruption, but I don't have sample data blocks. Please help me novice
Re: How do I corrupt a block
You can write a little perl script to write over the block. Just open the datafile, sysseek to (block_number)*(block_size), then syswrite(chr(0),block_size). Strangely though, the naive approach of overwriting a block entirely with nulls results in a block which is not detectable with dbms_repair (though you will definitely get a corrupt block error). If you want to be more clever (for example, altering the itl lists in the block, which is detectable by dbms_repair), then I would recommend do a formatted dump with alter system dump datafile the doing a raw dump of the block with dd if=... ibs=block_size skip=block_number count=1, viewing that with a hex editor and then comparing the two. The location and structure of the header components is pretty obvious. You can then use the method above to change what you want to change. Of course, doing any of this can damage your database beyond repair and you won't be supported by oracle support, etc. George - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 31, 2001 4:01 PM It apparently is only on NT, and unless you have the password, which is known only to Oracle Support Personnel, you can't use it. http://www.ixora.com.au/q+a/0101/23224038.htm Jared On Thursday 31 May 2001 12:10, K Gopalakrishnan wrote: Hi ! The simple thing is you can edit the datablocks using BBED editor. It is shipped with Oracle and You need a password to use that utility. You can browse and edit the data blocks. $BBED will give the required details. BUT IT IS DANGEROUS --- novicedba [EMAIL PROTECTED] wrote: hi, This may sound funny. I want to know how to corrupt a block. I want to test the different methods of identifying block corruption, but I don't have sample data blocks. Please help me novice = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Schlossnagle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: How do I corrupt a block
unfortunately i am on NT I can not use BBED because i don't know the password is there any other way - Original Message - To: 'novicedba' [EMAIL PROTECTED] Sent: Thursday, May 31, 2001 11:40 PM I do not recommend this, but since you are bent on doing this: (Hope you are on Unix) From an earlier post: Ferenc, try the following: dd if=/dev/zero of=myfile bs=4096 oseek=9876 count=100. If that doesn't corrupt it, nothing will. Happy hunting! === Mladen Gogala -Original Message- From: novicedba [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 2:16 PM To: Multiple recipients of list ORACLE-L Subject: How do I corrupt a block hi, This may sound funny. I want to know how to corrupt a block. I want to test the different methods of identifying block corruption, but I don't have sample data blocks. Please help me novice From another posting: Thanks to everyone who responded - this was the solution that worked for me: SVRMGR select count(*) from ccpinp; COUNT(*) -- ORA-01578: ORACLE data block corrupted (file # 4, block # 5204) ORA-01110: data file 4: '\SV\ALM\ADM\ALMDS1.TSP' SVRMGR select segment_name, segment_type from dba_extents 2 where file_id = 4 and 5204 between block_id and block_id + blocks - 1; SEGMENT_NAME SEGMENT_TYPE -- -- - CCPINP TABLE 1 row selected. SVRMGR select index_name from dba_indexes where table_name = 'CCPINP'; INDEX_NAME -- PK_CCPINP CCPINP_2 CCPINP_3 3 rows selected. SVRMGR create table temp as select * from ccpinp where 1 = 2; Statement processed. SVRMGR insert into temp select /*+ ROWID(CCPINP) */* 2 from ccpinp 3 where rowid between '..' and 4 '1453..0004'; 59 rows processed. SVRMGR insert into temp select /*+ ROWID(CCPINP) */* 2 from ccpinp 3 where rowid between '1455..0004' and 4 '..'; ORA-01578: ORACLE data block corrupted (file # 4, block # 5205) ORA-01110: data file 4: '\SV\ALM\ADM\ALMDS1.TSP' SVRMGR insert into temp select /*+ ROWID(CCPINP) */* 2 from ccpinp 3 where rowid between '1456..0004' and 4 '..'; ORA-01578: ORACLE data block corrupted (file # 4, block # 5206) ORA-01110: data file 4: '\SV\ALM\ADM\ALMDS1.TSP' SVRMGR insert into temp select /*+ ROWID(CCPINP) */* 2 from ccpinp 3 where rowid between '1457..0004' and 4 '..'; ORA-01578: ORACLE data block corrupted (file # 4, block # 5207) ORA-01110: data file 4: '\SV\ALM\ADM\ALMDS1.TSP' SVRMGR insert into temp select /*+ ROWID(CCPINP) */* 2 from ccpinp 3 where rowid between '1458..0004' and 4 '..'; 869 rows processed. And to look at the rows with the corruption, I did the following: SVRMGR select inst_id, chart_id, acct_id, attrib_id, rowid 2 from ccpinp 3 where inst_id =0 and chart_id =0 and acct_id =0 and attrib_id =0 4 and rowid like '1455.%.0004'; INST_ID CHART_ID ACCT_ID ATTRIB_ID ROWID -- -- -- -- -- 1 3 585 20 1455..0004 1 3 585 30 1455.0002.0004 1 3 585 50 1455.0004.0004 3 rows selected. SVRMGR select inst_id, chart_id, acct_id, attrib_id, rowid 2 from ccpinp 3 where inst_id =0 and chart_id =0 and acct_id =0 and attrib_id =0 4 and rowid like '1456.%.0004'; INST_ID CHART_ID ACCT_ID ATTRIB_ID ROWID -- -- -- -- -- 1 3 721 140 1456..0004 1 3 721 150 1456.0002.0004 1 3 721 160 1456.0005.0004 3 rows selected. SVRMGR select inst_id, chart_id, acct_id, attrib_id, rowid 2 from ccpinp 3 where inst_id =0 and chart_id =0 and acct_id =0 and attrib_id =0 4 and rowid like '1457.%.0004'; INST_ID CHART_ID ACCT_ID ATTRIB_ID ROWID -- -- -- -- -- 1 3 591 20 1457..0004 1 3 591 30 1457.0002.0004 1 3 591 40 1457.0004.0004 3 rows selected. Have a great weekend!! Jeff -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: novicedba INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: How do I corrupt a block
There are un-documented init.ora parameters that can be used to corrupt such things as the rollback segments and tablespaces. Maybe there is one that can be used to corrupt a specific block of a datafile as well. Contact ORacle Support and see if they have any of these. They would be undocumented and probably unsupported (i.e. use at your own risk) but if its a one time thing ... who cares. -Original Message- Sent: Thursday, May 31, 2001 5:06 PM To: Multiple recipients of list ORACLE-L unfortunately i am on NT I can not use BBED because i don't know the password is there any other way - Original Message - To: 'novicedba' [EMAIL PROTECTED] Sent: Thursday, May 31, 2001 11:40 PM I do not recommend this, but since you are bent on doing this: (Hope you are on Unix) From an earlier post: Ferenc, try the following: dd if=/dev/zero of=myfile bs=4096 oseek=9876 count=100. If that doesn't corrupt it, nothing will. Happy hunting! === Mladen Gogala -Original Message- From: novicedba [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 2:16 PM To: Multiple recipients of list ORACLE-L Subject: How do I corrupt a block hi, This may sound funny. I want to know how to corrupt a block. I want to test the different methods of identifying block corruption, but I don't have sample data blocks. Please help me novice From another posting: Thanks to everyone who responded - this was the solution that worked for me: SVRMGR select count(*) from ccpinp; COUNT(*) -- ORA-01578: ORACLE data block corrupted (file # 4, block # 5204) ORA-01110: data file 4: '\SV\ALM\ADM\ALMDS1.TSP' SVRMGR select segment_name, segment_type from dba_extents 2 where file_id = 4 and 5204 between block_id and block_id + blocks - 1; SEGMENT_NAME SEGMENT_TYPE -- -- - CCPINP TABLE 1 row selected. SVRMGR select index_name from dba_indexes where table_name = 'CCPINP'; INDEX_NAME -- PK_CCPINP CCPINP_2 CCPINP_3 3 rows selected. SVRMGR create table temp as select * from ccpinp where 1 = 2; Statement processed. SVRMGR insert into temp select /*+ ROWID(CCPINP) */* 2 from ccpinp 3 where rowid between '..' and 4 '1453..0004'; 59 rows processed. SVRMGR insert into temp select /*+ ROWID(CCPINP) */* 2 from ccpinp 3 where rowid between '1455..0004' and 4 '..'; ORA-01578: ORACLE data block corrupted (file # 4, block # 5205) ORA-01110: data file 4: '\SV\ALM\ADM\ALMDS1.TSP' SVRMGR insert into temp select /*+ ROWID(CCPINP) */* 2 from ccpinp 3 where rowid between '1456..0004' and 4 '..'; ORA-01578: ORACLE data block corrupted (file # 4, block # 5206) ORA-01110: data file 4: '\SV\ALM\ADM\ALMDS1.TSP' SVRMGR insert into temp select /*+ ROWID(CCPINP) */* 2 from ccpinp 3 where rowid between '1457..0004' and 4 '..'; ORA-01578: ORACLE data block corrupted (file # 4, block # 5207) ORA-01110: data file 4: '\SV\ALM\ADM\ALMDS1.TSP' SVRMGR insert into temp select /*+ ROWID(CCPINP) */* 2 from ccpinp 3 where rowid between '1458..0004' and 4 '..'; 869 rows processed. And to look at the rows with the corruption, I did the following: SVRMGR select inst_id, chart_id, acct_id, attrib_id, rowid 2 from ccpinp 3 where inst_id =0 and chart_id =0 and acct_id =0 and attrib_id =0 4 and rowid like '1455.%.0004'; INST_ID CHART_ID ACCT_ID ATTRIB_ID ROWID -- -- -- -- -- 1 3 585 20 1455..0004 1 3 585 30 1455.0002.0004 1 3 585 50 1455.0004.0004 3 rows selected. SVRMGR select inst_id, chart_id, acct_id, attrib_id, rowid 2 from ccpinp 3 where inst_id =0 and chart_id =0 and acct_id =0 and attrib_id =0 4 and rowid like '1456.%.0004'; INST_ID CHART_ID ACCT_ID ATTRIB_ID ROWID -- -- -- -- -- 1 3 721 140 1456..0004 1 3 721 150 1456.0002.0004 1 3 721 160 1456.0005.0004 3 rows selected. SVRMGR select inst_id, chart_id, acct_id, attrib_id, rowid 2 from ccpinp 3 where inst_id =0 and chart_id =0 and acct_id =0 and attrib_id =0 4 and rowid like '1457.%.0004'; INST_ID CHART_ID ACCT_ID ATTRIB_ID ROWID -- -- -- -- -- 1 3 591 20 1457..0004 1 3 591 30 1457.0002.0004 1 3 591 40 1457.0004.0004 3 rows selected. Have a great weekend!! Jeff -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: novicedba INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message
RE: How do I corrupt a block
talk to your lead duhveloper..they are usally good at that ;-) Sunil Nookala Dell Corp Austin, TX -Original Message- Sent: Thursday, May 31, 2001 5:06 PM To: Multiple recipients of list ORACLE-L unfortunately i am on NT I can not use BBED because i don't know the password is there any other way - Original Message - To: 'novicedba' [EMAIL PROTECTED] Sent: Thursday, May 31, 2001 11:40 PM I do not recommend this, but since you are bent on doing this: (Hope you are on Unix) From an earlier post: Ferenc, try the following: dd if=/dev/zero of=myfile bs=4096 oseek=9876 count=100. If that doesn't corrupt it, nothing will. Happy hunting! === Mladen Gogala -Original Message- From: novicedba [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 2:16 PM To: Multiple recipients of list ORACLE-L Subject: How do I corrupt a block hi, This may sound funny. I want to know how to corrupt a block. I want to test the different methods of identifying block corruption, but I don't have sample data blocks. Please help me novice From another posting: Thanks to everyone who responded - this was the solution that worked for me: SVRMGR select count(*) from ccpinp; COUNT(*) -- ORA-01578: ORACLE data block corrupted (file # 4, block # 5204) ORA-01110: data file 4: '\SV\ALM\ADM\ALMDS1.TSP' SVRMGR select segment_name, segment_type from dba_extents 2 where file_id = 4 and 5204 between block_id and block_id + blocks - 1; SEGMENT_NAME SEGMENT_TYPE -- -- - CCPINP TABLE 1 row selected. SVRMGR select index_name from dba_indexes where table_name = 'CCPINP'; INDEX_NAME -- PK_CCPINP CCPINP_2 CCPINP_3 3 rows selected. SVRMGR create table temp as select * from ccpinp where 1 = 2; Statement processed. SVRMGR insert into temp select /*+ ROWID(CCPINP) */* 2 from ccpinp 3 where rowid between '..' and 4 '1453..0004'; 59 rows processed. SVRMGR insert into temp select /*+ ROWID(CCPINP) */* 2 from ccpinp 3 where rowid between '1455..0004' and 4 '..'; ORA-01578: ORACLE data block corrupted (file # 4, block # 5205) ORA-01110: data file 4: '\SV\ALM\ADM\ALMDS1.TSP' SVRMGR insert into temp select /*+ ROWID(CCPINP) */* 2 from ccpinp 3 where rowid between '1456..0004' and 4 '..'; ORA-01578: ORACLE data block corrupted (file # 4, block # 5206) ORA-01110: data file 4: '\SV\ALM\ADM\ALMDS1.TSP' SVRMGR insert into temp select /*+ ROWID(CCPINP) */* 2 from ccpinp 3 where rowid between '1457..0004' and 4 '..'; ORA-01578: ORACLE data block corrupted (file # 4, block # 5207) ORA-01110: data file 4: '\SV\ALM\ADM\ALMDS1.TSP' SVRMGR insert into temp select /*+ ROWID(CCPINP) */* 2 from ccpinp 3 where rowid between '1458..0004' and 4 '..'; 869 rows processed. And to look at the rows with the corruption, I did the following: SVRMGR select inst_id, chart_id, acct_id, attrib_id, rowid 2 from ccpinp 3 where inst_id =0 and chart_id =0 and acct_id =0 and attrib_id =0 4 and rowid like '1455.%.0004'; INST_ID CHART_ID ACCT_ID ATTRIB_ID ROWID -- -- -- -- -- 1 3 585 20 1455..0004 1 3 585 30 1455.0002.0004 1 3 585 50 1455.0004.0004 3 rows selected. SVRMGR select inst_id, chart_id, acct_id, attrib_id, rowid 2 from ccpinp 3 where inst_id =0 and chart_id =0 and acct_id =0 and attrib_id =0 4 and rowid like '1456.%.0004'; INST_ID CHART_ID ACCT_ID ATTRIB_ID ROWID -- -- -- -- -- 1 3 721 140 1456..0004 1 3 721 150 1456.0002.0004 1 3 721 160 1456.0005.0004 3 rows selected. SVRMGR select inst_id, chart_id, acct_id, attrib_id, rowid 2 from ccpinp 3 where inst_id =0 and chart_id =0 and acct_id =0 and attrib_id =0 4 and rowid like '1457.%.0004'; INST_ID CHART_ID ACCT_ID ATTRIB_ID ROWID -- -- -- -- -- 1 3 591 20 1457..0004 1 3 591 30 1457.0002.0004 1 3 591 40 1457.0004.0004 3 rows selected. Have a great weekend!! Jeff -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: novicedba INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L
Re: How do I corrupt a block
BBED isn't an option unless you can talk Oracle support into taking part in your experiment - unlikely. (Or perhaps find an appropriate WaReZ site! (8-o) Any hex editor will do if you aren't particular about exactly what you change in the block. If you know Oracle block internals you can get a lot more sophisticated in what you corrupt. As for simply corrupting a block, I have done it even with good old emacs/vi - as an experiment. [WARNING: This isn't for the faint of heart! Don't try it with any database you can't afford to lose or large data files!] (For raw devices, you can: 1. dd if=raw device of=some file 2. munge the file with an editor - hex or otherwise 3. dd if=some file of=raw device ) The best way, in my opinion, is to shut all instances down, edit the datafile, then restart the instance(s). YMMV Happy hacking! -Don Granaman [certifiable OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 31, 2001 3:01 PM It apparently is only on NT, and unless you have the password, which is known only to Oracle Support Personnel, you can't use it. http://www.ixora.com.au/q+a/0101/23224038.htm Jared On Thursday 31 May 2001 12:10, K Gopalakrishnan wrote: Hi ! The simple thing is you can edit the datablocks using BBED editor. It is shipped with Oracle and You need a password to use that utility. You can browse and edit the data blocks. $BBED will give the required details. BUT IT IS DANGEROUS --- novicedba [EMAIL PROTECTED] wrote: hi, This may sound funny. I want to know how to corrupt a block. I want to test the different methods of identifying block corruption, but I don't have sample data blocks. Please help me novice = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: How do I corrupt a block
Jared, BBED is available on UNIX, you just have to make it with the make command. cd $ORACLE_HOME/rdbms/lib make -f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbed The bbed command can allow you to soft corrupt a block and you can use the dd command to hard corrupt the block. The bbed command does have a password and its a secret ;) Scott It apparently is only on NT, and unless you have the password, which is known only to Oracle Support Personnel, you can't use it. http://www.ixora.com.au/q+a/0101/23224038.htm Jared On Thursday 31 May 2001 12:10, K Gopalakrishnan wrote: Hi ! The simple thing is you can edit the datablocks using BBED editor. It is shipped with Oracle and You need a password to use that utility. You can browse and edit the data blocks. $BBED will give the required details. BUT IT IS DANGEROUS --- novicedba [EMAIL PROTECTED] wrote: hi, This may sound funny. I want to know how to corrupt a block. I want to test the different methods of identifying block corruption, but I don't have sample data blocks. Please help me novice = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).