Re: Delete command and commit

Mika Niiranen <mika.niiranen_at_ttgroup.fi> wrote:

: Hi,
 

: I have a table with 100 000 rows and I have tried to delete all the
: rows, but rollback segment becomes full and delete command fails.
 

: I tried to use Oracle's autocommit feature (set autocommit immediate),
: but same thing happens...
 

: Is there easy way to delete all the rows?
 

: -= Mika =-
 

: ---------------------------------387293229386--

try:

TRUNCATE TABLE <tablename>

--
 
John Blackburn                           Phone: +61 7 32534634
jb2_at_qdot.qld.gov.au                      Fax:   +61 7 38541194

"Please enclose a stamped, self-addressed ethernet packet with
 all correspondence..."

#include <std_disclaimers.h>