Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DROP TABLE always takes long time.
On Tue, 13 Jan 1998 17:08:39 GMT, chuckh_at_dvol.com (Chuck Hamilton) wrote:
>What would cause all DROP TABLE commands, even on the simplest of
>tables, those with no indexes, rows, or constraints, to take an
>inordinately long time?
>
>For example:
>
> CREATE TABLE mytable (
> name VARCHAR2(10),
> qty NUMBER(9,0)
> );
>
>takes about 2 seconds. But
>
> DROP TABLE MYTABLE;
>
>takes 3.5 minutes;
Try truncating the table before you drop it. Truncate does not right the the rollback segments, but drop does. It can really speed things up if theres much data in the tables. Received on Fri Jan 16 1998 - 00:00:00 CST