Rollback info .

From: Andrey Bronfin <bronfin_at_VisualTop.com>
Date: Sun, 12 Nov 2000 17:33:30 +0200
Message-Id: <10678.121832@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_0021_01C04CCE.AC1E8870 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Dear gurus !
Some questions regarding rollback and/or redo , please :

Is there a way to do a "un-rollback-able transaction" , i.e not to = produce any rollback for a transaction ? =20
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 ?
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

------=_NextPart_000_0021_01C04CCE.AC1E8870 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#dfdcd7>
<DIV><FONT face=3DArial size=3D2>Dear gurus !</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Some questions regarding rollback =
and/or redo ,=20
please :</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>1) Is there a way to do a =
"un-rollback-able=20
transaction" , i.e not to produce any rollback for a transaction = ?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2> </FONT></DIV>
<DIV><FONT face=3DArial size=3D2>2) I'm using a lot of SQL*Loader during =
my batch=20
loads .</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>   Is there a way not to =
generate any=20
rollback or redo for those loads , but still to keep everything = recoverable=20
?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>3) Is there a way to specify "SET =
TRANSACTION USE=20
ROLLBACK SEGMENT ...." for those SQL*Loader loads ?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>    And for imports =
?</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanks a lot in advance .</FONT></DIV>
<DIV><FONT face=3DArial size=3D2><BR>Andrey =
Bronfin<BR>Navixo.com<BR></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2><BR></FONT> </DIV></BODY></HTML>
Received on Sun Nov 12 2000 - 09:33:30 CST