Re: Using Set Transation statement??

You have a large transaction. That way you can assign it to a large rollback segment. If you do not then you can generate a snapshot too old error.

"JAP" <jasonperez_at_mindspring.com> wrote in message news:94dlmj$ebh$2_at_slb7.atl.mindspring.net...
> I am reviewing PL/SQL for my OCP test. I understand the syntax of <Set
> Transaction Use Rollback Segment random_label; > but I don't understand
 why
> it exists. Why would you us a Set Transaction? Does anyone have a tangible
> real-world type example? The book uses a banking systems example (Sybex;
> Oracle8i DBA SQL and PL/SQL study guide; page 183, Chip Dawes, Biju
 Thomas).
>
> Thanks for the help.
> JAP
>
>
>
>
>
Received on Sat Jan 20 2001 - 23:19:50 CST