RE: Insert into remote table from Read only database
- From: "Elliott, Patrick" <patrick.elliott@xxxxxxxxxxxxx>
- To: "finn.oracledba@xxxxxxxxx" <finn.oracledba@xxxxxxxxx>, "mark.powell@xxxxxxx" <mark.powell@xxxxxxx>
- Date: Thu, 28 Aug 2008 13:08:02 -0500
Thanks for testing that for us, and I am happy to be proven wrong.
Pat
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Finn Jorgensen
Sent: Thursday, August 28, 2008 11:38 AM
To: mark.powell@xxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Insert into remote table from Read only database
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 ....
--
//www.freelists.org/webpage/oracle-l
[CONFIDENTIALITY AND PRIVACY NOTICE]
Information transmitted by this email is proprietary to Medtronic and is
intended for use only by the individual or entity to which it is addressed, and
may contain information that is private, privileged, confidential or exempt
from disclosure under applicable law. If you are not the intended recipient or
it appears that this mail has been forwarded to you without proper authority,
you are notified that any use or dissemination of this information in any
manner is strictly prohibited. In such cases, please delete this mail from your
records.
To view this notice in other languages you can either select the following link
or manually copy and paste the link into the address bar of a web browser:
http://emaildisclaimer.medtronic.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
