How to drop a tablespace when datafile is lost

From: <lbrenta_at_my-deja.com>
Date: Mon, 22 Nov 1999 17:17:38 GMT
Message-ID: <81btr4$7t4$1@nnrp1.deja.com>

Hello,

One of the datafiles in my database has been lost. This is not a big deal, because it was the only datafile in a tablespace that was not in use anyway. Now I want to drop the tablespace.

Unfortunately, a rollback segment was in that tablespace (and datafile) and it gets in the way. I can't drop it because I get the ORA-01545 error message when trying to do so. I can't alter it to bring it either online or offline since the datafile is gone.

I'm not interested in recovering the datafile, and even if I were, I have no archived redo logs or backups for that particular datafile. I also don't want to lose my other tablespaces, but I can afford to shut down the instance.

So, the question boils down to this: how can I nuke a tablespace when the datafile is gone?

Any help will be appreciated

--
Ludo.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Nov 22 1999 - 11:17:38 CST