Re: Insert into remote table from Read only database

From: Finn Jorgensen <>
Date: Thu, 28 Aug 2008 12:37:49 -0400
Message-ID: <>

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.


On Thu, Aug 28, 2008 at 11:17 AM, Powell, Mark D <> wrote:
> Distributed transactions take DX locks and use undo entries ....

Received on Thu Aug 28 2008 - 11:37:49 CDT

Original text of this message