Re: fastest way to drop a user

From: TurkBear <jgreco1_at_mn.rr.com>
Date: Tue, 27 Aug 2002 08:49:00 -0500
Message-ID: <4n0nmu010a43qkmcj8qqk87o54g4a8sqjb@4ax.com>

You could use Sql to spool out to a file the commands needed to drop each object, but that may not be faster. If the tablespace is the only place he has objects, then dropping the tablespace WITH CONTENTS should eliminate them which should make the drop user CASCADE go faster... .
"Kåre Sangolt" <kare.sangolt_at_ttyl.com> wrote:

>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.
>

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Tue Aug 27 2002 - 08:49:00 CDT