RE: Insert into remote table from Read only database

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!
 

> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx 
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Elliott, Patrick
> Sent: Friday, August 29, 2008 02:08
> To: finn.oracledba@xxxxxxxxx; mark.powell@xxxxxxx
> Cc: oracle-l@xxxxxxxxxxxxx
> 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@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';

--
http://www.freelists.org/webpage/oracle-l

Other related posts: