Re: Copy data through db link with different version!

Hi,

    Because the select statement is very quickly, so I think the index on column A is using. However, I suspect it is because of the inefficient compunction of sqlnet 2.3.4 and net8. I have another db3 with the same configure as db2 and where I copy 100 row of data from db3 to db2, it only take a tenth of second. However, when I am copying 10 row from db1 to db2, it almost take me 7 minute. Do anyone have idea of this problem.

    TIA. Man

tmgn <tmgn_at_excite.com> wrote in message news:378B7EE4.C49CF115_at_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 - 20:46:20 CDT