Re: Rollback Segment and how to use the statement "Set transaction use rollback segment ???"

If I'm not mistaken:

The SET TRANSACTION USE ROLLBACK SEGMENT.... statement must be the first statement of a new transaction, and it is valid until a COMMIT is issued. Any ALTER statement is DDL, therefore it issues a COMMIT prior to doing it's operation.

Regards,

--
David C. Sisk
Need tech info on Oracle? Visit The Unofficial ORACLE on NT site at http://www.ipass.net/~davesisk/oont.htm Like original music? Listen to song samples and buy a CD at http://www.mp3.com/disparityofcult

Wind wrote in message <37c7d88c.52317052_at_news.earthlink.net>...
>
>Hi guys,
>
>
> I am trying to use sql statement "set transaction use rollback
>segment bigroll" to set that Oracle will set the "bigroll" (a much
>bigger rollback segment in size) to do the analyze on some tables.
>However, I got this error message:
>
>analyze table episodes estimate statistics sample 50 percent
>*
>ERROR at line 1:
>ORA-01555: snapshot too old: rollback segment number 21 with name
>"R20" too small
>
>while the sql statements used are liike this:
>
>set transaction use rollback segment bigroll;
>analyze table episodes estimate statistics sample 50 percent;
>
>but "bigroll" is not R20. How did that happen? Can someone explain
>to me how rollback segments work?
>
>
>please either post your reply here or send email to me using
>mleung_at_earthlink.net or mleung_at_intelus.com
>
>thanks in advance
>
>Michael Leung
>
>
>
>
>WindyCloud
>7k_at_gamestats.com
>
>Realms of the Kingdoms, http://7k.gamestats.com
>
Received on Sun Aug 29 1999 - 20:19:36 CDT