Re: Insert into remote table from Read only database

This works fine in general, we do it on a daily basis where the standby DB is opened read-only for a set time for the ETL to do extracts.

A few things that don't work are when you use partition or sub-partition name with the table in the from clause, Oracle throws an error. There is a work around though .. I believe

-Arul

On Thu, Aug 28, 2008 at 11:08 AM, Elliott, Patrick < patrick.elliott_at_medtronic.com> wrote:

> 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';
>
> Database link created.
>
> TESTDB> insert into finn select * from finn_at_rotest;
>
> 1 row created.
>
> TESTDB> commit;
>
> Commit complete.
>
> Finn
>
> On Thu, Aug 28, 2008 at 11:17 AM, Powell, Mark D <mark.powell_at_eds.com>
> wrote:
> >
> > Distributed transactions take DX locks and use undo entries ....
> --
> http://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
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Arul

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