Corrupted Datafile in Tablespace

From: Christian Hofer <nospam_at_please.com>
Date: 1998/03/03
Message-ID: <350336f7.2276383@gateway.axioma.co.at>#1/1

Hello!

I have troubles with a tablespace under Oracle 7.3 (AIX 4.1).

The tablespace has been turned into offline mode and because of a corrupted datafile it can't be turned online again without recovering the datafile first. Because I have neither a backup nor an archivelog I can't recover the datafile.

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?
The command "alter database datafile 'filename' offline drop" doesn't help, because in the tablespace the link to the datafile isn't removed!

Thanks for any help!

Christian Hofer Received on Tue Mar 03 1998 - 00:00:00 CST