private rollback segments are used mostly with OPS... the rollback segment
is "private" to an instance (ie, unseen by the other instance(s))
>From: "Kevin Kostyszyn" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Rollback Segments
>Date: Wed, 09 May 2001 07:20:53 -0800
>
>Hi all,
> This brings me to a stupid question then. What is the true difference
>between a public and a private rollback segment? Because if I just think
>about it like a normal human being I would think that if a user made a
>Private rollback segment then only that user could use it, but of course I
>know that can't be the case.
>Kev
>
>-----Original Message-----
>Sent: Wednesday, May 09, 2001 10:26 AM
>To: Multiple recipients of list ORACLE-L
>
>
>
>Nixon,
>
>While SET TRANSACTION can be used to assign a rollback
>segment to a transaction, it cannot be assigned exclusively to
>that transaction as you have found.
>
>The ability to assign a rollback segment to a transaction and
>make it read-only for all others is something I've wanted myself
>for many years, and I know it's been on the official 'wish list' of
>requested changes by IOUG for some time.
>
>Maybe 9i? Anyone know?
>
>Jared
>
>
>On Wednesday 09 May 2001 01:40, [EMAIL PROTECTED] wrote:
> > Hi All,
> >
> > Here is my environment;
> >
> > NT v4
> > Db Oracle Workgroup v8.1.6
> >
> > Rollback Segments
> > SEGMENT_NAME OWNER TABLESPACE_NAME
> > ------------------------------ ------ ------------------------------
> > SYSTEM SYS SYSTEM
> > RBS0 PUBLIC RBS
> > RBS_P1 SYS RBS
> > RBS_P2 SYS RBS
> > RBS_P3 SYS RBS
> > RBS_P4 SYS RBS
> > RBS_P5 SYS RBS
> >
> >
> > Is it possible to assign one public rollback segment explicitly to one
> > particular transaction? I tried using SET TRANSACTION USE ROLLBACK
>SEGMENT
> > but other users I found out can still use it. So, I guess the best
> > alternative is to set that RB segment to OFFLINE after using and set
>ONLINE
> > before executing the SET TRANSACTION ... Do you know how it can be done
> > inside Forms?
> >
> > Thanks in advance!
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Jared Still
> INET: [EMAIL PROTECTED]
>
>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: [EMAIL PROTECTED] (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: Kevin Kostyszyn
> INET: [EMAIL PROTECTED]
>
>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: [EMAIL PROTECTED] (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: Rachel Carmichael
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
