-
database link from one machine to another
hi,
I need to set up one or more
database links.
We have a test server and a live server.
What the requirement is, is to transfer data from the test server from one instance, to one or other of three instances on the live server.
I am new, and a little unsure, what is the best way to do this using one or more database links, and what do I have to do.
Which way round should it be ... do I create the db links on the live server pointing to the one instance on the test server, or do I create three db links on the test server pointing at the three instances on the live server?
Also, presumably because they are on seperate servers, I need to add tnsnames entries as well - again, which side do I do thin on and how do I do it?
Has anyone got an example of this?
-
I will suggest to do an export/import.
Export the required data from the test server into a dump file and import it on the live servers as you specified.
Best regards,
Tarun Dua
-
and why do you suggest that
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
|