Re: looking for a a faster way to drop a schema

From: L. Tseng <lesliet_at_u.washington.edu>
Date: 1997/05/23
Message-ID: <5m5583$v8o@nntp6.u.washington.edu>#1/1

So 'drop user USERNAME with cascade' is logged and can be rolled back? It does not seem to be so for drop procedure and other objects, though. what does exactly Oracle do when drop usera with cascade? Anybody know? Thanks.

In article <338470b2.3826734_at_news.interserv.com>, Sheilah Scheurich <scheuric_at_sprynet.com> wrote:
>It may not be the command that is the problem, It may be where your
>rollback tablespace and redo logs are located. You may be getting
>into some IO contention. Check to see that they are not on the same
>disk as your data and indexes, and are separate from each other.
>
>-Sheilah Scheurich
>DBA
>scheuric_at_sprynet.com
Received on Fri May 23 1997 - 00:00:00 CDT