Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Rollback Segments
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).Received on Wed May 09 2001 - 11:59:58 CDT