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" <Kirsten.deWeerd_at_Oranjewoud.nl> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> 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_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).
Received on Mon Jul 31 2000 - 22:37:03 CDT