Re: Cleanup tablespace after deleting the dbf file!

From: Terry Dykstra <dont_reply_tddykstra_at_forestoil.ca>
Date: Mon, 06 May 2002 20:36:18 GMT
Message-ID: <6PBB8.20811$rS5.850522@news2.telusplanet.net>

startup mount and then take the tablespace offline. Then drop it.

--
Terry Dykstra
Canadian Forest Oil Ltd.
"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message
news:3CD6DAD3.7236696D_at_exesolutions.com...


> Sathya wrote:

>

> > Hi,

> > I erroneously deleted the dbf file of a tablespace.

> > Now, I am unable to create or delete that particular tablespace.

> >

> > Anyway to cleanup?

> >

> > Sathya

>

> And that is why backups were invented.  ;-)

>

> Daniel Morgan

>

Received on Mon May 06 2002 - 15:36:18 CDT