Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to corrupt oracle block

Re: How to corrupt oracle block

From: <srivenu_at_hotmail.com>
Date: 11 Nov 2005 12:23:30 -0800
Message-ID: <1131740610.645848.106060@g44g2000cwa.googlegroups.com>


For playing around i would do this
Create my own tablespace
create tablespace x datafile 'X01.DBF' size 10m; create table x(A number,b varchar2(10)) tablespace x; insert into x values(1,'SRIVENU');
Now i can see srivenu in the file. This means i can edit a few characters here or there that is in that block. if you are using windows, it will not allow you to open the file with another program like word.
so make a copy of the file.
(Just make sure that the data is flushed to the disk before you open or copy the file using this
alter tablespace x offline
alter tablespace x online)
regards
srivenu Received on Fri Nov 11 2005 - 14:23:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US