delete without transaction?

Hi,

is there a way to delete rows in a table without using any rollbacksegment?

If you have a BLOB column with huge data in it, the duration of the delete statement for a row is very long due to the generation of rollback information.

To reduce the generated rollback information during the regular processing you could make an update on the row to mark it as deleteable. Later another process could go through the table and delete all the rows marked for delete.

At this point a transaction is not more needed, because you want to remove all the rows which are no more in use. Is it possible to delete these rows without a transaction generating rollback information?

I know that deleting a row is a DML statement and that it has to be within an transaction. However is there any way to remove the rows with huge BLOB data in a faster way when a savety transaction is not needed?

Thank you.

kind regards
Yadi Ata

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 05 2000 - 08:58:48 CDT