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.