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@xxxxxxxxxxxxx> wrote:

> 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 ....
> --
> 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

Other related posts: