fastest way to drop a user

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Tue, 27 Aug 2002 15:50:21 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA702900905@lnewton.leeds.lfs.co.uk>

Hi Kåre,

if you are on 8i, then create the user's tablespaces as Locally Managed with Uniform extent sizes.
That will make subsequent drops of the user - or its objects - much quicker.

I know it won't help this time though .....

In the past, I've dropped the tablespace(s) for the user then dropped the user itself. This is the quickest way I've found to do it.

Regards,
Norman.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: Kåre Sangolt [mailto:kare.sangolt_at_ttyl.com] Posted At: Tuesday, August 27, 2002 1:45 PM Posted To: server
Conversation: fastest way to drop a user Subject: fastest way to drop a user

Hi,

anyone having an opinion on what is the fastest way to drop a user ?. In our
environment, the user is schema owner of thousands of object, including tables and indexes. The user has its own tablespace, that can be drop'ed with no consequences to other users. If I drop the user cascade this takes
"ours" to finish. Anyone having suggestion / ideas of what could be the fastest way to drop the user ?

best regards
Kåre. Received on Tue Aug 27 2002 - 09:50:21 CDT