Message-Id: <10570.112995@fatcity.com> From: ddorr.cs@clearstream.com Date: Wed, 26 Jul 2000 14:06:54 +0200 Subject: RE: Removing datafiles > ---------- > From: Weerd de E.C. Kirsten[SMTP:Kirsten.deWeerd@Oranjewoud.nl] > Reply To: ORACLE-L@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@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@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).