Re: Dropping Tablespaces - All Nighter

Busy all night rebuilding a database too? Is it some kind of plage here in Holland?

Isn't your problem in the rollback you don't need? Isn't it an idea to truncate the tables before you drop them?

This can be easily done by a script like this;

select 'truncate table '||table_name||';'   from dba_tables
 where owner = '<owner>'

spool trunc_user.sql

/

spool off

@trunc_user

Good morning to you,
Eric Lansu, working all night for a rebuild of Sonera's customer database |-O

• 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
Received on Mon Jul 31 2000 - 22:32:23 CDT