RE: Rollback segments and DB links

From: Roman Mirzaitov <mromka_at_MailAndNews.com>
Date: Thu, 19 Jul 2001 23:59:32 -0400
Message-ID: <3B5DE20B@MailAndNews.com>

>===== Original Message From "Brian Pulcine"
<bpulcine_at_nospam.bellatlantic.net> =====
>Can anyone tell me if I perform an UPDATE to another DB through a DB link,
>am I using the rollback of the current database (the one I'm logged into),
>or the remote DB?
>
>SQL> UPDATE table1_at_remotedb SET col1='dummy' WHERE col2=5;
>
>Will the above statement create the "before" data image in my local
>database's rollback segments, or on "remotedb"?
>
>Thanks!
>-Brian
>

Hi Brian,

Will be used a rollback segment on the local side. Also you can read *Transparency in a Distributed Database System* from Oracle
8i Concepts.

Roman Mirzaitov
Brainbench MVP for Oracle Administration www.brainbench.com Received on Thu Jul 19 2001 - 22:59:32 CDT