Re: Slow INSERT across database link

Could you clarify a little?
If you just do:
select * from table1, table2_at_remote_database were .... (join statement).

it is fast but if you add the
insert into xxxx as
to it is gets very slow?

If that is the case and a
insert into xxxx as select * from table2_at_remotedatabase where table2.somefield = somevalue  is also fast,
I suspect the fact that the db link can not use an index is somehow involved ...but I don't see how..

also it is not clear whether you are selecting * from both tables ( one of which is a remote db linked one) and inserting into a third table ( local)..

"Steven" <steven.pannell_at_gmx.net> wrote:

>Hi,
>
>I have a remote database where I select data and insert it in my local
>database across a database link. However, this is very, very slow. I have
>a statement such as:
>
>insert into xxxx as
> select * from table1, table2_at_remote_database
> were .... (join statement).
>
>The problem seems to be the fact I have a select across two databases (if
>there is no select across the database an insert from the tables on the
>remote database is quite fast). The current insert takes 2 hours! but the
>select only 5 minutes. I tried using the DRIVING_SITE hint but this only
>speeds up the select not the insert.
>
>Does anyone know of a solution to this problem. I read the Oracle
>Documentation but it was not really clear how I solve this particular
>problem.
>
>Any help would be greatly appreciated.
>
>Regards,
>Steve.
>
>

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Fri Jun 14 2002 - 08:54:33 CDT