Re: fastest way to drop a user

"K?re Sangolt" 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.

Out of curiosity, do you drop them often? Received on Sat Aug 31 2002 - 00:11:29 CDT