Hi John,
Thanks for the response, to use the DRIVING_SITE hint I have 22 table used by select query from Remote Database, I should specify all the 22 table name in the palce of "remotetablename" or any one of the table?

thanks
mallma