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 Tue Aug 10 1999 - 21:07:01 CDT
