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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Slow deleting records

Re: Slow deleting records

From: Quinton McCombs <quintonm_at_bellsouth.net>
Date: 1998/11/03
Message-ID: <363F3218.773F6D20@bellsouth.net>#1/1

Since truncate is a ddl command and not dml, it can not be rolled back. In fact, it has an implied commit which will cause any uncommitted work to be committed when you issue the command. Oh, and the person executing the truncate command must have alter rights to the table.

"Kevin P. Fleming" wrote:
>
> >I have a table that only has 15000+ records but when I try to delete all
 the
> >records it takes forever. We benched marked it to about 15 minutes per
 1000
> >records. The only thing I can think that may cause this is that this table
> >has a long datatype field but most records are very small.
> >
> >Any ideas would be appreciated.
> >
> >
>
> If you really want to delete _ALL_ the records, use the TRUNCATE command.
> It's instant, and can recover the storage allocated to the table as well if
> you like.
  Received on Tue Nov 03 1998 - 00:00:00 CST

Original text of this message

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