I have to move all the rows of table a into table b(append). They both reside on two different servers. I need to perform some edits on the data in table a. More precisely, an entire column needs to be changed. Table A rows need to be deleted after the completion. Could you please tell me a fast and efficient method? Thank you.
a fast and efficient method would be to read the documentation about distributed databases and database links. You might then followup with a reading of the SQL manual and maybe the Concepts manual as well...
Reply With Quote
Bookmarks