| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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).
 |
 |