Re: delete without transaction?

I wonder if you can consider using discrete transactions to achieve this. Oracle manual at
http://technet.oracle.com/doc/oracle8i_816/server.816/a76965/c15trans.htm#22 2 says:

This transaction design eliminates the need to generate undo information, since the block is not modified until the transaction is committed, and the redo information is stored in the redo log buffers.

But Oracle recommends only using discrete transaction on short, small data change.

Yong Huang
yhuang_at_indigopool.com

<yadiata_at_my-deja.com> wrote in message news: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.
Received on Mon Oct 09 2000 - 17:14:52 CDT