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 -> How to specify rollback segment?

How to specify rollback segment?

From: Venkata <venkata_at_inetnow.net>
Date: 1998/03/14
Message-ID: <350a0f55.0@news.inetnow.net>#1/1

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