Re: DROP TABLE always takes long time.

Why does drop table generate rollback when a DDL command automatically does a commit. You cannot rollback a drop table. Right?

Scott

draggs_at_hawkeye.idx.com wrote:

> 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 Sat Jan 17 1998 - 00:00:00 CST