Re: Pick a rollback segment

See below for an off the wall idea.

>==========Mike Morgan, 8/23/96==========
>
>Randy <rmramos.gbs_at_worldnet.att.net> wrote:
>>gcherer_at_millenium.texas.net (GT Cherer) wrote:
>>>any way to get exclusive use of a big mama rollback segment?
>>>seem that other apps can use it thru some sort of defaulting
 arrangements.
>>>when they use it, however, it can mess up my appl when
 scheduling it for
>>>roll offline (when they alter it rolled online) or roll
 on(when they have
>>>it altered to roll offline).
>>>
>>>how do you guys handle an unknown number of apps vying for the same
>>>giganto rollback segment?
>>>
>>> --
>>>G.T. Jeff Cherer gcherer_at_texas.net
>>>"There's a new life on the other side of the barricade."
>>>Les Mis
>>*******************
>>SET TRANSACTION USE Bigmamma;
>>
>>Hope this helps
>>R2
>>Independent ORacle Consultant
>>
>
>Yes, but this does not exclude others from using Bigmama.
>
>

Create a second database instance with a huge RBS and db_links to the primary db. Run your sql from the second db.

Ron Beery
NCR
"Everything is computerized. What could possibly go wrong?" Received on Mon Aug 26 1996 - 00:00:00 CEST