Re: Disabling Rollback segments

gwong_at_nortel.com (Gary Wong) wrote:

>I am trying to disable a transaction from using rollback. I am updating a
>large temp table with a single update statement and the rollback segments
>are too small to handle it.
 

>Is there a why to do this?
 

>Thanks in advance.

If you find out please let me know. The only solution I've ever come up with isn't very good. Create a special rollback segment big enough for these infrequent large transactions and do a SET TRANSACTION USE ROLLBACK SEGMENT xxx.

--
Chuck Hamilton
chuckh_at_ix.netcom.com

Incoming fire has the right of way!