Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: looking for a a faster way to drop a schema

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US