11gR2 : Optimize INSERT SELECT over dblink
Hi ,
I would like to optimize the following SQL :
INSERT INTO remote_table@dblink SELECT * FROM local_table ;
Database version 11.2.0.3
Local table contains 15 000 000 rows(partitioned)
Duration : 10 minutes.
Any tips to improve this INSERT ?
Best regards.
GD.
0