Re: Using a Rollback Segment within a SQR

[Kenny Melton <KMELTO1@TANDY.COM>]

Sheeja,

If you are using an Oracle database, try this:

BEGIN-SQL

SET TRANSACTION USE ROLLBACK SEGMENT RBIG

END-SQL

Where RBIG is an actual segment name (that is on-line, of course).  I have
used this with success.  Remember that a "commit" ends the transaction, so
you must issue the above statement after each explicit commit in the
program.

Good Luck,
Kenny

-----Original Message-----
From: Sheeja John [mailto:Sjohn@LYDALL.COM]
Sent: Thursday, July 08, 1999 2:33 PM
To: Multiple recipients of list SQR-USERS
Subject: Using a Rollback Segment within a SQR


Hi --
I'm trying to specify a name of a rollback segment within a SQR. The SQR is
an interface that inserts records into temporary tables and quite often it
errors because of the rollback segment being small. (The inserts are in
10,000's ).
I tried using 'DBMS_TRANSACTION.USE_ROLLBACK_SEGMENT("RBIG") to choose the
biggest available rollback segment, but does not work.
Does anybody have any input on this ?
Any kind of input is appreciated ....

Thanks
Sheeja