Slow INSERT across database link

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. Received on Fri Jun 14 2002 - 08:18:00 CDT