Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> problem while execuitng query using DB Link.

problem while execuitng query using DB Link.

From: mahesh <mahesh2425_at_gmail.com>
Date: 28 Mar 2007 03:09:35 -0700
Message-ID: <1175076575.771373.272910@y66g2000hsf.googlegroups.com>


Hi while executing this dblink query the toad is hangs so please tell me ia there anything wrong with this query

INSERT INTO DEST_DUPLI_MESSAGE_at_ltsb.us.oracle.com
(TXN_ID,COUNTRY_CODE,TXN_SOURCE,DEST_CODE,IN_TIME,DUPLI_MESSAGE_ID,MESSAGE)
(SELECT

TXN_ID,COUNTRY_CODE,TXN_SOURCE,DEST_CODE,IN_TIME,DUPLI_MESSAGE_ID,MESSAGE FROM DEST_DUPLI_MESSAGE WHERE TXN_ID IN (SELECT TXN_ID FROM TEMP)) Received on Wed Mar 28 2007 - 05:09:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US