Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 19617 invoked from network); 28 Aug 2008 10:19:30 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by air964.startdedicated.com with SMTP; 28 Aug 2008 10:19:30 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 331A3923583; Thu, 28 Aug 2008 11:19:30 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 17714-03; Thu, 28 Aug 2008 11:19:30 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 992A49232F9; Thu, 28 Aug 2008 11:19:29 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 28 Aug 2008 11:17:33 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4107992378C for ; Thu, 28 Aug 2008 11:17:33 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 17431-05 for ; Thu, 28 Aug 2008 11:17:33 -0400 (EDT) Received: from plmler11.mail.eds.com (plmler11.mail.eds.com [199.228.142.91]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0CD11923786 for ; Thu, 28 Aug 2008 11:17:32 -0400 (EDT) Received: from plmlir4.mail.eds.com (plmlir4-2.mail.eds.com [199.228.142.134]) by plmler11.mail.eds.com (8.14.2/8.13.8) with ESMTP id m7SFHWb5029390 for ; Thu, 28 Aug 2008 10:17:32 -0500 Received: from plmlir4.mail.eds.com ([148.94.169.150]) by plmlir4.mail.eds.com (8.13.8/8.12.10) with ESMTP id m7SFHW7t016244 for ; Thu, 28 Aug 2008 10:17:32 -0500 Received: from plmlir4.mail.eds.com (localhost [127.0.0.1]) by plmlir4.mail.eds.com (8.13.8/8.12.10) with ESMTP id m7SFHOnY015681 for ; Thu, 28 Aug 2008 10:17:24 -0500 Received: from usplm015.amer.corp.eds.com ([148.94.166.8]) by plmlir4.mail.eds.com (8.13.8/8.12.10) with ESMTP id m7SFHOuG015676 for ; Thu, 28 Aug 2008 10:17:24 -0500 X-EDSINT-Source-Ip: 148.94.166.8 Received: from usahm208.amer.corp.eds.com ([130.175.198.40]) by usplm015.amer.corp.eds.com with Microsoft SMTPSVC(6.0.3790.3959); Thu, 28 Aug 2008 10:17:24 -0500 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Subject: RE: Insert into remote table from Read only database Date: Thu, 28 Aug 2008 11:17:21 -0400 Message-ID: In-Reply-To: <3B8B6A1700202C43A89D61CE495C894E0F2A531E50@MSPM1BMSGM103.ent.core.medtronic.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Insert into remote table from Read only database From: "Powell, Mark D" To: X-OriginalArrivalTime: 28 Aug 2008 15:17:24.0314 (UTC) FILETIME=[2C9283A0:01C90921] X-CFilter-Loop: Reflected X-archive-position: 10481 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: mark.powell@eds.com Precedence: normal Reply-to: mark.powell@eds.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain Distributed transactions take DX locks and use undo entries so how about converting the database to Read/Write and converting each user data tablespace to Read Only. I would think, though I have not tested, this would work as a workaround to the problem. -- Mark D Powell -- Phone (313) 592-5148 -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Elliott, Patrick Sent: Thursday, August 28, 2008 10:43 AM To: finn.oracledba@gmail.com; debaditya.chatterjee@gmail.com Cc: oracle-l@freelists.org Subject: RE: Insert into remote table from Read only database I have a suspicion that even pulling data will not work. It won't hurt to try it, but I have seen select statements across a dblink that issued distributed locks in the source database, and this might not be allowed in a RO database. Pat -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Finn Jorgensen Sent: Thursday, August 28, 2008 9:16 AM To: debaditya.chatterjee@gmail.com Cc: oracle-l@freelists.org Subject: Re: Insert into remote table from Read only database Deba, Could you go the other way? Create a link from the RW database to the RO database and do an "insert into select from @RO"? Finn -- 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 -- http://www.freelists.org/webpage/oracle-l