Re: How do I delete a tablespace after I deleted the data file by mistake?

Thank you James. It worked like a charm.

The only thing different I did was not to take the tablespace offline. It was dropped anyways.

Thanks again.

Junlei

In article <7va8k3$b75$1_at_nnrp1.deja.com>,   James Lorenzen <james_lorenzen_at_allianzlife.com> wrote:
> It's been awhile, but I believe that you can clear this up by going
into
> svrmgr:
> 1. STARTUP MOUNT
> 2. ALTER DATABASE DATAFILE 'filename' OFFLINE DROP ;
> — This will remove the missing datafile from the database.
> 3. ALTER TABLESPACE tablespace_name OFFLINE ;
> — This should take the tablespace offline.
> 4. ALTER DATABASE OPEN ;
> 5. DROP TABLESPACE tablespace_name ;
>
> HTH
> James
> In article <7va5ki$8sg$1_at_nnrp1.deja.com>,
> junlei_at_my-deja.com wrote:
> > In the process of creating a bunch of tablespaces, I made a mistake
> > with the initial extent size for some tablespaces. I decided to
> > delete them.
> > Then I proceeded to delelte the corresponding datafiles. That's
when
> > I mistakenly deleted 2 datafiles corresponding to two tablespaces
not
> > yet deleted. Now, I can't do anything to these two tablespaces,
> > not even to take them offline. So I have set the quoto to none on
> > these tablespaces for the time being.
> >
> > Does anyone know how I can solve this problem?
> >
> > Thanks.
> >
> > Junlei
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 28 1999 - 15:21:15 CDT