Re: Cleanup tablespace after deleting the dbf file!

From: Hemant K Chitale <hkchital_nospam_at_singnet_nospam.com.sg>
Date: Tue, 7 May 2002 23:19:25 +0800
Message-ID: <ab8rj8$3ff$1@violet.singnet.com.sg>

You can't take the Tablespace Offline in a Mount mode. STARTUP MOUNT only reads the control files -- the Instance would then be aware of only the physical data files not the logical tablespaces. You could try taking each datafile in that tablespace offline. If you are in NOARCHIVELOG, you can do an ALTER DATABASE DATAFILE <filename> OFFLINE DROP to directly drop the datafile [this wouldn't remove the physical file from the file system, only the entry in the control file].

Hemant K Chitale
http://hkchital.tripod.com
"Terry Dykstra" <dont_reply_tddykstra_at_forestoil.ca> wrote in message news:6PBB8.20811$rS5.850522_at_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 Tue May 07 2002 - 10:19:25 CDT