Message-Id: <10678.121835@fatcity.com> From: Charlie Mengler Date: Sun, 12 Nov 2000 08:54:55 -0800 Subject: Re: Rollback info . --------------7828C8FC84A41B6E3EA539E2 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit DIRECT=Y will not create redo entries. Of course, some options are NOT available when using Direct. It is a classic case of trade-offs; where you can't get something for nothing. HTH & YMMV Andrey Bronfin wrote: > Dear gurus !Some questions regarding rollback and/or redo , please > : 1) Is there a way to do a "un-rollback-able transaction" , i.e not > to produce any rollback for a transaction ? 2) I'm using a lot of > SQL*Loader during my batch loads . Is there a way not to generate > any rollback or redo for those loads , but still to keep everything > recoverable ? 3) Is there a way to specify "SET TRANSACTION USE > ROLLBACK SEGMENT ...." for those SQL*Loader loads ? And for imports > ? Thanks a lot in advance . > Andrey Bronfin > Navixo.com --------------7828C8FC84A41B6E3EA539E2 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit DIRECT=Y will not create redo entries.

Of course, some options are NOT available when using Direct.
It is a classic case of trade-offs; where you can't get something for nothing.

HTH & YMMV

Andrey Bronfin wrote:

Dear gurus !Some questions regarding rollback and/or redo , please : 1) Is there a way to do a "un-rollback-able transaction" , i.e not to produce any rollback for a transaction ? 2) I'm using a lot of SQL*Loader during my batch loads . Is there a way not to generate any rollback or redo for those loads , but still to keep everything recoverable ? 3) Is there a way to specify "SET TRANSACTION USE ROLLBACK SEGMENT ...." for those SQL*Loader loads ? And for imports ? Thanks a lot in advance .
Andrey Bronfin
Navixo.com