My apologies : I've read too quickly !
I've read " DROP tablespace ..." and then " ... remove datafile" ( at the OS
level, of course ).
Sorry :-(
> ----------
> From: Rachel Carmichael[SMTP:carmichr_at_hotmail.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Wednesday, July 26, 2000 16:45
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Removing datafiles
>
> NO!!!!!!!!!!!!!
>
> there is no such command as alter tablespace remove datafile.
>
> if you want to get rid of the datafile, you will have to drop the
> tablespace
> and recreate it without that file.
>
>
> >From: ddorr.cs_at_clearstream.com
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: RE: Removing datafiles
> >Date: Wed, 26 Jul 2000 05:21:26 -0800
> >
> >
> >
> > > ----------
> > > From: Weerd de E.C. Kirsten[SMTP:Kirsten.deWeerd_at_Oranjewoud.nl]
> > > Reply To: ORACLE-L_at_fatcity.com
> > > Sent: Wednesday, July 26, 2000 11:16
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: Removing datafiles
> > >
> > > Hi all,
> > >
> > > Yeah yeah, I should know this, but I'm just out of a two weeks 'Forget
>
> >it
> > > all'-vacation, and I simply can't remember and don't have the
> necessary
> > > docs
> > > to find it.
> > >
> > > There are several tablespaces that I want to export, drop everything
> and
> > > recreate with an import.
> > >
> > > Dropping everything is very easy using : Drop User ... cascade ;
> > > When the datafiles are empty, I want to remove them so that I can
> >replace
> > > and resize them more appropriately.
> > >
> > > Is it as simple is I think it is : Alter Tablespace ... Remove
> datafile
> >YES !
> >
> > > '...' ;
> > >
> > > Thanx for your attention!
> > >
> > > Greets,
> > >
> > > Kirsten
> > >
> > > --
> > > Author: Weerd de E.C. Kirsten
> > > INET: Kirsten.deWeerd_at_Oranjewoud.nl
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > San Diego, California -- Public Internet access / Mailing Lists
> > > --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like subscribing).
> > >
> >--
> >Author:
> > INET: ddorr.cs_at_clearstream.com
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing Lists
> >--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
>
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
> --
> Author: Rachel Carmichael
> INET: carmichr_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Wed Jul 26 2000 - 09:59:19 CDT
