Re: Delete command and commit

If you want to delete _all the rows_ in the table, you can truncate the table.

e.g. truncate table xyz;

Note - there is no rollback option when you truncate a table, and it's all or nothing (no partial truncate).BTW, it also commits any uncommited transactions you may have hanging.

You can also create a larger rollback segment, if you haven't tried that already.

YMMV, Phil

In article <30C4DED2.4F65_at_ttgroup.fi>, Mika Niiranen <mika.niiranen_at_ttgroup.fi> says:
>
>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 =-
Received on Tue Dec 05 1995 - 00:00:00 CET