Re: Problem dropping tablespace

Hi,

You have to set the datafile offline with the command:

ALTER DATABASE DATAFILE '...' OFFLINE DROP; Than You can drop the Tablespace.

--
Best Regards,

Ralph Ganszky

• The above opinions are mine and do not represent any official
• standpoints of my employer or third-party organizations.

Vijay Mayadas wrote:

> I can't take the tablespace offline when I deleted the datafile.
>
> NetComrade <andreyNSPAM_at_bookexchange.net> wrote in message
> news:37b0a231.18435980_at_news.earthlink.net...
> > 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
> >
Received on Wed Aug 11 1999 - 01:59:46 CDT