-
table download upload
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...
Jeff Hunter
-
Or, you might choose to read the SQL*Plus manual about the COPY command.
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|