Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How to specify rollback segment?
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