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 =-

truncate table <table_name> [reuse storage];

-- 
Henry Ballen				Senior Database Administrator
Information Services Dept.		Phone: 	612 628-7156
SIMS Deltec, Inc.  MS6570		Fax: 	612 639-2530
St. Paul, MN 55112			E-mail:	hballen_at_deltec.com