Moving datafile

[Yogeeraj_1]

hi fabio,

i would prefer to do a safe:

a. create new tablespace
b. move tables to new tablespace using: 'alter table move tablespace
c. rebuild associated indexes


how big is the tablespace?

kind regards
yogeeraj

[fabiosax]

Hi..
about 160Mb with 135Md of data.
The problem is that the actual datafile has 3 blocks corrupted and after having tried to fix them i had problems fixing orphan keys.
So i thought to replace the actual datafile with an old one but with less data and with the same structure.
Sorry for all my questions but i' trying to fix something i never faced.
So I wonder if exist a method to replace the actual defect datafile with an old one but with less data.
Thanks yogeeraj really appreciated!!!
//FAbio

[Yogeeraj_1]

hi fabio,

this is the last help that i can provide you for today.

A document containing information on how to Handle Oracle Block Corruptions in Oracle7/8/8i/9i/10g

hope this helps!

kind regards
yogeeraj

[fabiosax]

Thanks so much.
Regards
//Fabio

[Yogeeraj_1]

hi fabio,

hope you managed to fix the problem.

keep us updated.

kind regaards
yogeeraj

[fabiosax]

Hello there,
just to let you know that we managed to fix the problem avoiding to use the old datafile.
We just used the rowid to select data from the corrupted datafile ( the errors was into a table) and then insert it to a new table.

Thanks to everyone for your support.
Regards,
Fabio