Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to specify rollback segment?

Re: How to specify rollback segment?

From: David <darussell_at_email.msn.com>
Date: 1998/03/14
Message-ID: <uWnkus2T9GA.252@upnetnews02.moswest.msn.net>#1/1

The line immediatemly before the SET TRANSACTION statement must be a COMMIT and then it should work.

Regards
David Russell

Venkata wrote in message <350a0f55.0_at_news.inetnow.net>...
>Hi! I have a question about specifying a rollback segment for a specific
>transaction. I tried putting the line SET TRANSACTION USE ROLLBACK SEGMENT
>xyz before an anonymous PL/SQL block that loops and inserts a few hundred
>thousand rows into the database. It comes back with an error saying SET
>TRANSACTION USE ROLLBACK SEGMENT has to be the first statement in a
>transaction.
>My question is how do you specify the use of a rollback segment in an SQL
>Plus script?
>
>TIA
>
>
>
>
Received on Sat Mar 14 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US