[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Using a Rollback Segment within a SQR
- Subject: Using a Rollback Segment within a SQR
- From: Sheeja John <Sjohn@LYDALL.COM>
- Date: Thu, 8 Jul 1999 15:32:59 -0400
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