Re: Insert into remote table from Read only database

From: "Finn Jorgensen" <finn.oracledba@xxxxxxxxx>
To: mark.powell@xxxxxxx
Date: Thu, 28 Aug 2008 12:37:49 -0400

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@rotest;

1 row created.

TESTDB> commit;

Commit complete.

Finn

On Thu, Aug 28, 2008 at 11:17 AM, Powell, Mark D <mark.powell@xxxxxxx> wrote:
>
> Distributed transactions take DX locks and use undo entries ....
--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

RE: Insert into remote table from Read only database
From: Elliott, Patrick

References:
- RE: Insert into remote table from Read only database
  - From: Elliott, Patrick
- RE: Insert into remote table from Read only database
  - From: Powell, Mark D

Re: Insert into remote table from Read only database

Other related posts: