Message-Id: <10575.113445@fatcity.com> From: "Eric Lansu" Date: Tue, 1 Aug 2000 05:37:03 +0200 Subject: Re: Dropping Tablespaces - All Nighter Oh, and I forgot my tip on the import; Specify a big buffer, like 1M (1048576). The proposed buffer is veeeery small, and takes hours more to complete! Also, the analyze = no, and commit = yes if you have large tables. Nothing better than a full rbs at the last table :-( Eric Lansu ----- Original Message ----- From: "Weerd de E.C. Kirsten" To: "Multiple recipients of list ORACLE-L" Sent: Monday, 31 July 2000 20:49 Subject: Dropping Tablespaces - All Nighter > Hi, > > At this rate, this is gonna take all night ... So any advice as to how speed > things up a little would be greatly appreciated ... > > I have to remove several tablespaces. The basic steps I use at this moment > are : > > 1. Make an export of the main user, just in case (He is owner of every > object that could be of any importance) > > 2. Drop all Tables of this particular user (One of my last resorts to speed > things up, don't really know if it helps at all) > > 3. Take the tablespace offline and issue a 'Drop tablespace X including > contents' > This is one that is taking quite some time. > > 4. Drop the main user : 'Drop User X Cascade' > Another one to stare at for quite a while. > > 5. Remove the datafiles on OS-level. > > After that it's creating a new TS, with a new main-user and importing etc. > > Someone suggested downing the database after dropping the tables, which > could speed up dropping both TS and user, but don't know if he's right, or > just guessing as I am. > > Thanx again for all the help ! > > 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).