Re: Help... Can I *not* use a rollback?

From: Alan D. Mills <alanmNOSPAM_at_uk.europe.mcd.mot.com>
Date: Fri, 7 Aug 1998 13:57:58 +0100
Message-ID: <6qetk5$5vj$1@schbbs.mot.com>

The only way I know of performing DML without using the rollback segments si to entorely remove all records from table using

TRUNCATE TABLE mytable;

But my guess is, this is not what you're looking for.

Other than that, I also think it's not possible.

Why would you not want to use the rollback segments anyway?

--
Alan D. Mills

>>
>> Does anyone know how to force a transaction *NOT* to use any rollback
segment
>> at all. Using the "SET TRANSACTION" I only seem able to change which
rollback
>> segment it's using.
>hi eric,
>
>sorry but thats not possible
Received on Fri Aug 07 1998 - 07:57:58 CDT