Re: Rollback info .

From: Charlie Mengler <charliem_at_mwh.com>
Date: Sun, 12 Nov 2000 08:54:55 -0800
Message-Id: <10678.121835@fatcity.com>

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

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">

<html>
<body bgcolor="#DFDCD7">
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.

<p>HTH &amp; YMMV
<p>Andrey Bronfin wrote:
<blockquote TYPE=CITE><style></style>
<font face="Arial"><font size=-1>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  </blockquote>

</body> Received on Sun Nov 12 2000 - 10:54:55 CST