Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Problem dropping tablespace

Re: Problem dropping tablespace

From: Ralph Ganszky <ralph.ganszky_at_sap-ag.de>
Date: Wed, 11 Aug 1999 08:59:46 +0200
Message-ID: <37B11F62.5C5F206B@sap-ag.de>


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

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US