Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Performance Issues on Insert Statement to Remote Table

Re: Performance Issues on Insert Statement to Remote Table

From: Anurag Varma <avoracle_at_gmail.com>
Date: 20 Mar 2006 11:49:17 -0800
Message-ID: <1142884157.708383.58750@u72g2000cwu.googlegroups.com>


As Jonathan stated, driving_site hint is probably not being respected in your version.

Try creating your select statement as a view on the *remote* database. Then do a insert ... select * from view_at_ndw;

Anurag Received on Mon Mar 20 2006 - 13:49:17 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US