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