Re: HELP!Remove Data Files

Alter database datafile offline drop does not really remove the datafile. You have to drop the tablespace including the datafile and then remove the file from the OS. If you don't want to do that, just resize the datafile to as small as possible and live with it.

Yong Huang
yhuang_at_indigopool.com

Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message news:971042547.8405.2.pluto.d4ee154e_at_news.demon.nl...
> I agree with your last remark.
> However, just FYI, I have been flamed several times for making similar
> remarks.
>
> Regards,
>
> Sybrand Bakker, Oracle DBA
>
> "Howard J. Rogers" <howardjr_at_www.com> wrote in message
> news:39e0cd0a_at_news.iprimus.com.au...
> > Alter database datafile offline drop
> >
> > Have you read *any* of the documentation that came with Oracle?
> > Regards
> > HJR
> > --
>
> --------------------------------------------------------------------------
> > Opinions expressed are my own, and not those of Oracle Corporation
> > Oracle DBA Resources:

 http://www.geocities.com/howardjr2000
>
> --------------------------------------------------------------------------
> >
> > "Ho" <kowho_at_singnet.com.sg> wrote in message
> > news:8rqgdi$cbu$5_at_coco.singnet.com.sg...
> > > We can add datafile through ALTER TABLESPACE ADD DATAFILE.....
> > >
> > > How to remove/delete the datafile ?
> > >
> > > Many thanks for your help.
Received on Mon Oct 09 2000 - 15:30:04 CDT