Re: Delete command and commit
From: Joan Colley <joan_c_at_adc.com.au>
Date: 1995/12/11
Message-ID: <DJF49x.Jzo_at_online.tmx.com.au>#1/1
Date: 1995/12/11
Message-ID: <DJF49x.Jzo_at_online.tmx.com.au>#1/1
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 =-
Try 'truncate'
Joan. Received on Mon Dec 11 1995 - 00:00:00 CET