Re: set rollback segment through link

bsonia_at_my-deja.com wrote:
>
> Hello,
>
> I have 2 databases: A and B. I have a dblink from A to B. B has one
> big rollback segment for large transactions and the rest are small.
> From A, I would like to execute a large insert into B using the DBlink.
>
> Does anyone know how I can explicitly set the transaction rollback
> segment on B when using a database link?
>
> NOTE: Due to network settings, it is impossible to create a link from B
> to A.
>
> Thanks,
>
> Bill Sonia
> Achaia Solutions, Inc
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

There is a pl/sql function to do this I think...something like DBMS_TRANSACTION.SET... Give that a whirl...

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"