Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Dropping Tables - Slow Performance
Try to truncate the data of the tables first. Truncate remove data without
using rollbacks.
Jeanne schrieb in Nachricht <78tqqo$akt_at_bgtnsc01.worldnet.att.net>...
> I am running scripts that drop numerous tables in a database for a
>software upgrade. It is taking up to a minute just to drop a table. Our
>DBA just shrugs and goes and gets coffee. None of the tables has any
>constraints, other than explicitly created indexes, and we don't maintain
>histograms.
> Anyone have any ideas on where I could look?
>
>
Received on Sat Jan 30 1999 - 08:21:14 CST