Ron.
Was this ever a "fast" method of inserting data? There are a lot of =
factors to consider with the work around you have created. The speed of =
the network at the time you are sending the data, the activity on the =
different boxes, the activity on the database. How much free memory do you =
have in the middle server? If you are sending data through a dblink I =
don't think the receiving database does much with it except use memory or =
temp space and then passes it on to the next link and finally to the =
table.=20
That is the method you are doing is't it. Or is it getting loaded into a =
table in the middle server and then select...insert._at_last server?
Ron
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 08 2005 - 12:33:30 CDT
