From Waleed.Khedr@FMR.COM Thu, 29 Mar 2001 12:32:53 -0800 From: "Khedr, Waleed" Date: Thu, 29 Mar 2001 12:32:53 -0800 Subject: RE: Set transaction does not work Message-ID: MIME-Version: 1.0 Content-Type: text/plain First test: try to remove any settings for the OPTIMAL parameter for all the RBSegments -----Original Message----- Sent: Thursday, March 29, 2001 12:51 PM To: Multiple recipients of list ORACLE-L 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@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@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@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@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@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@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@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@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: Khedr, Waleed INET: Waleed.Khedr@FMR.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@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).