Re: Insert into remote table from Read only database
From: Finn Jorgensen <finn.oracledba_at_gmail.com>
Date: Thu, 28 Aug 2008 12:37:49 -0400
Message-ID: <74f79c6b0808280937u281f6f8ft7341f59fd6558415@mail.gmail.com>
Date: Thu, 28 Aug 2008 12:37:49 -0400
Message-ID: <74f79c6b0808280937u281f6f8ft7341f59fd6558415@mail.gmail.com>
My method works fine.
I opened a standby database read only and then from the primary :
TESTDB> create database link rotest using 'rotest';
Database link created.
TESTDB> insert into finn select * from finn_at_rotest;
1 row created.
TESTDB> commit;
Commit complete.
Finn
On Thu, Aug 28, 2008 at 11:17 AM, Powell, Mark D <mark.powell_at_eds.com> wrote:
>
> Distributed transactions take DX locks and use undo entries ....
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 28 2008 - 11:37:49 CDT