Re: problem while execuitng query using DB Link.

mahesh wrote:
> 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))
>

Try executing the same query in SQL*Plus. If it does not hang, then the problem is with Toad.

If it still hangs in SQL*Plus, then the INSERT statement is most likely waiting on something. You'll have to look at the wait events to see what it is waiting on.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com