Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to corrupt oracle block
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