Copy data through db link with different version!

From: Yeung Man <yngm_at_chowsangsang.com>
Date: Tue, 13 Jul 1999 19:10:15 +0800
Message-ID: <7mf6na$kfn$1@news.hk.linkage.net>

Hi,

There are two tables with same name TAB1 in DB1 a DB2 which DB1 is Oracle Enterprise Server 7.3.4.2 on Digital Unix with sqlnet version 2.3.4 and DB2 is 8.0.5.1 with net8 on WinNT. DB1 and DB2 both have db link point to each other. When I issue "select * from tab1_at_db1 where colA='xxx';" the result appear quick. However, if I issue " insert into TAB2 ( select * from tab1_at_db1 where colA='xxx');" , it hang up and no response in SQL*.

Do anyone know what is happen?
TIA. Best Regards,
Man
yngm_at_chowsangsang.com Received on Tue Jul 13 1999 - 06:10:15 CDT