Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Rollback segments over database link?

Rollback segments over database link?

From: Lothar Armbrüster <lothar.armbruester_at_rheingau.netsurf.de>
Date: 13 Aug 98 19:39:35 +0100
Message-ID: <611.529T1794T11794005@rheingau.netsurf.de>


Hello out there,

I want to insert data into a table on a remote databse using a database link.
I have a specific rollback segment on the remote database that ist large enough to handle large transactions.
Now the question is: Is it possible to set the rollback segment over a database link?
Setting the rollback segmrnt locally using

set transaction use rollback segment rb_big;

does not work for the remote database.
Any ideas?

Thanks in advance,
Lothar

--

Lothar Armbrüster       | lothar.armbruester_at_rheingau.netsurf.de
Schulstr. 12            | lothar.armbruester_at_t-online.de
D-65375 Oestrich-Winkel |

Received on Thu Aug 13 1998 - 13:39:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US