Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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
![]() |
![]() |