DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: database link from one machine to another

  1. #1
    Join Date
    Aug 2005
    Posts
    69

    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?

  2. #2
    Join Date
    Jul 2005
    Posts
    3
    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

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    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
  •  


Click Here to Expand Forum to Full Width