Unable to corrupt data file for testing

user11102480

Nip-Oracle

You should post it in "Discussions" section.
Cheers!

user2302459

For simulating the corrupted datafile only:

1. down load HEDIT.exe

2. create the table using tablespace with the datafile.

3. insert some records into table

4. make the corrupted datafile : open the datafile with HEDIT.exe and change hex values to whatever and save.

you would see error "datafile corruption" when select * from table.

if no error occurs then you may not change the memory part of the data yet, open and change another hex values.

Phong Dang

Oracle DBA