Re: Drop tablespaces with missing datafiles

From: Sudarshan Sampath <ssampath_at_scr.siemens.com>
Date: Tue, 27 Jul 1999 11:49:44 -0400
Message-ID: <379DD518.995D7AF3@scr.siemens.com>

Try taking the tablespace offline first and then dropping it later. Or do an ALTER
tablespace add datafile, then drop it.

Sam Jordan 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 - 10:49:44 CDT