RE: Set transaction does not work

Where is the transaction?

Alex Hillman

        -----Original Message-----
        From:   blair_at_pjm.com [SMTP:blair_at_pjm.com]
        Sent:   Thursday, March 29, 2001 12:51 PM
        To:     Multiple recipients of list ORACLE-L
        Subject:        Set transaction does not work

        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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hillman, Alex
  INET: Alex.Hillman_at_usmint.treas.gov

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).