Re: Set transaction does not work

Under your situation of select only statement there is no use of rollback segment whether big or small. This error is a result of some other long running job using that rollback segment. Please advise relevant developer to check his code doing some delete,update,insert and intoduce some commit size in his code first. To implement set transaction use commit first like

commit;
set transaction use rollback segment BIG_ROLLBACK; then your sql or code

HTH
Regards
Rafiq

Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Thu, 29 Mar 2001 09:50:55 -0800

RDBMS 7.3.2.3 I am running this under SQLPLUS

set transaction use rollback segment BIG_ROLLBACK

select c1, c2
from giant_poorly_indexed_table
where unindexed_colum='****';

exit;

I end up with "snapshot too old" rollback segment RB_07.

Why won't it use the giant rollback segment I created for this transaction? The
segment is public and it is online.

> -----Original Message-----
> From: Brian Wisniewski [SMTP:brian_wisniewski_at_yahoo.com]
> Sent: Thursday, March 29, 2001 7:45 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Is terminal release of 8.0.x still supported?
>
> I checked yesterday and 8.0.6 which is the terminal 8.0.X release is
> still supported on Solaris. Freakin' vendor won't certify their
> product for anything above 8.0.5 which hasn't been supported for nearly
> a year now. mumble, mumble...
>
> - Brian
>
> --- Cherie_Machler_at_gelco.com wrote:
> >
> > We have some 8.0.4 databases running on Sun Solaris.
> > I believe that 8.0.4 has been desupported as of December 31, 2000.
> > We are unable to upgrade one of our apps at this time that is
> > running on an 8.0.4 database.
> >
> > Is the terminal release of 8.0.x still supported? If yes, what is
> > that terminal release? Is it 8.0.7? How long before that terminal
> > release will be desupported (if it is currently supported)?
> >
> > Thanks,
> >
> > Cherie Machler
> > Gelco Information Network
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> > INET: Cherie_Machler_at_gelco.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing
> > Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
>
> __________________________________________________
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail.
> http://personal.mail.yahoo.com/?.refer=text
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Brian Wisniewski
> INET: brian_wisniewski_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
   INET: blair_at_pjm.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohammad Rafiq
  INET: rafiq9857_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).