| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Rollback Segments
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" <kevin_at_dulcian.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>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, Nixon_Villanueva_at_manulife.com 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: jkstill_at_cybcon.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: Kevin Kostyszyn
> INET: kevin_at_dulcian.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: Rachel Carmichael INET: carmichr_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).Received on Wed May 09 2001 - 13:20:47 CDT
 |
 |