Oracle-L: Re: undo tablespace and set transaction use rollback segment

From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Tue, 29 Jul 2003 02:19:23 -0800
Message-ID: <F001.005C7A22.20030729021923@fatcity.com>

Hi!

You can't anymore.
Either:
1) remove set transaction commands from your scripts 2) if can't remove 'em, set undo_suppress_errors=true in spfile/init.ora that your scripts wont error out
3) use old fashioned rollback segments - set undo_management=manual in parameter file.

Tanel.

Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, July 29, 2003 1:04 PM

>
> when we were using oracle8i , whe had some process which use "set
transaction use rollback segment".
> and now we use undo tablespace and we have still same porocesses .
> how can set a rollbback segment for process with undo tablepsace
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: <A.Bahar_at_billing-components.com
> INET: A.Bahar_at_billing-components.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).

Received on Tue Jul 29 2003 - 05:19:23 CDT