Re: delete without transaction?

BLOBs themselves are not written to rollback on delete, but there will be an update to the lob index which is protected by rollback and redo. Since a lob index entry identies only a few lob chunks, it may be that your lobindex contains a LOT of entries for your huge LOB.

What is your CHUNKSIZE ? Perhaps you need to recreate the LOB with a much large chunksize.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

yadiata_at_my-deja.com wrote in message <8ri1ej$2rc$1_at_nnrp1.deja.com>...


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