Re: Copy data through db link with different version!

From: tmgn <tmgn_at_excite.com>
Date: Tue, 13 Jul 1999 14:01:08 -0400
Message-ID: <378B7EE4.C49CF115@excite.com>

Maybe the Optimiser is not using the Index on colA.

-Thiru

Yeung Man wrote:

> 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 - 13:01:08 CDT