Re: Rollback segments and DB links

From: Patrick SINAGRA <sinagra_at_wanadoo.fr>
Date: Fri, 20 Jul 2001 06:27:36 +0200
Message-ID: <9j8c4f$d49$1@wanadoo.fr>

When you send a DML syntax with a table on a database link the syntax is sent to the remote database and local database is client. Update is executed on remote db.
So before image is on remote db.

"Brian Pulcine" <bpulcine_at_nospam.bellatlantic.net> a écrit dans le message news: dRL57.18668$O81.6848548_at_typhoon1.gnilink.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
>
>
Received on Thu Jul 19 2001 - 23:27:36 CDT