Re: Problem dropping tablespace

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

On Tue, 10 Aug 1999 17:59:11 -0700, "Vijay Mayadas" <vijay_at_winwin.com> wrote:

>I've lost the datafile for one of my tablespaces and wish to drop the
>tablespace and recreate it.
>
>The problem is I am going round and round in circles trying to drop the
>tablespace because it is expecting to find the datafile. I've also tried to
>alter the tablespace and rename the datafile but again, it expects the old
>datafile to be there.
>
>What do I need to do to drop the tablespace.
>
>Help appreciated.
>
>Vijay
>
>

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 373-5417
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email