Re: Corrupted Datafile in Tablespace

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 1998/03/03
Message-ID: <6ditnq$rif$1@hermes.is.co.za>#1/1

Christian Hofer wrote in message <350336f7.2276383_at_gateway.axioma.co.at>...
>Is there a possibility to completely remove the link to the corrupted
>datafile in the tablespace configuration, so I can put the tablespace
>online again?

Not without some very low level hacking.

>The command "alter database datafile 'filename' offline drop" doesn't
>help, because in the tablespace the link to the datafile isn't
>removed!

You need to drop the tablespace too. If a datafile is stuffed beyond recovery and you do not have a backup of either the datafile or the tablespace, then you have lost the tablespace.

regards,
Billy Received on Tue Mar 03 1998 - 00:00:00 CST