Re: Delete without Rollback ?

If you have to delete all the rows, in that case you can use the truncate table command, which will not use the rollback segments.

The syntax for this is:
Truncate table TABLE_NAME;

If you try to truncate a table that acts as parent in a foreign key constraints then Oracle will return you an error. Another thing to be noted is that the delete triggers will no get fired in this case on the table being truncated, this is just to make you aware so that you know what you are doing.

If you think truncate is appropriate for you, then disable the foreign key constraint in all the tables where this table is referenced as foreign key.

Hope this helps,
Manoj Jain
OCP/Chauncey Certified DBA

In article <35C85724.CCE4EA38_at_a.com>,
  John Finn <a_at_a.com> wrote:
> Does anyone know how to Delete without Rollback transaction overhead?
>
> "DELETE FROM TABLE1 WHERE ..."
>
> and no transaction overhead, rollback, commit ...
>
> thanks
> jfinn
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Aug 05 1998 - 11:21:22 CDT