Re: drop user xyz cascade sooo sloww...

"Bob T" <bob.mailist_at_gmail.com> wrote in news:1128377007.711084.263390_at_z14g2000cwz.googlegroups.com:

> I drop and rebuild users regularly in my development environment.
> In earlier versions of Oracle, dropping a user was really quick,
> but now it takes more than half an hour to drop a user with 100 tables;
>
> Is there any way to speed this up?
>
> Would it go faster if I disabled all constraints first?
>
> How about if I truncated tables directly, or dropped them individually?
>
> I could write a script to do any of those things, but it seems to me
> that drop user xxxx cascade should be smart enough to optimize the
> process.
>
> It occurs to me that the reason for the delay might be that Oracle is
> creating all those "undo" tables. I don't need or want them, but I
> don't know how to
> turn that off, if it is possible.
>
> Thanx for any help!
> Bob
>
>

You may have flooded the flashback history repository Received on Mon Oct 03 2005 - 20:56:07 CDT