Re: Drop tablespaces with missing datafiles

Take tablespace offline
Take datafiles offline (alter database datafile 'bla-bla-bla' offline) Drop datafiles (alter database datafile 'bla' drop) Drop tablespace

I think this should work, doublecheck the syntax

On Tue, 27 Jul 1999 12:44:39 +0000, Sam Jordan <sjo_at_spin.ch> wrote:

>Hi
>
>I would like to drop a tablespace, which doesn't have any content.
>By some mistake the datafiles are gone. Now Oracle refuses to
>drop the tablespace, because the datafiles aren't present, and I
>can't rebuild the tablespace because it's still present. Any ideas
>how to solve that?
>
>bye
>--
>Sam Jordan
Received on Tue Jul 27 1999 - 09:47:51 CDT