RE: Insert into remote table from Read only database
From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Fri, 29 Aug 2008 02:28:50 +0800
Message-id: <632BE6C1C33D4702BC2B82B85D267323@windows01>
Date: Fri, 29 Aug 2008 02:28:50 +0800
Message-id: <632BE6C1C33D4702BC2B82B85D267323@windows01>
When you select over dblink from a database which is opened read only, there
is no need to create a distributed transaction there...
-- Regards, Tanel Poder http://blog.tanelpoder.com http://n.otepad.com - n.ote this!Received on Thu Aug 28 2008 - 13:28:50 CDT
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Elliott, Patrick
> Sent: Friday, August 29, 2008 02:08
> To: finn.oracledba_at_gmail.com; mark.powell_at_eds.com
> Cc: oracle-l_at_freelists.org
> Subject: RE: Insert into remote table from Read only database
>
> Thanks for testing that for us, and I am happy to be proven wrong.
>
>
> Pat
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Finn Jorgensen
> Sent: Thursday, August 28, 2008 11:38 AM
> To: mark.powell_at_eds.com
> Cc: oracle-l_at_freelists.org
> 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';
-- http://www.freelists.org/webpage/oracle-l