Results 1 to 4 of 4
  1. #1
    Join Date
    May 2004

    Unanswered: Oracle on Windows to Oracle on Unix connectivity

    I have got a problem in data migration. Basically I want to do following steps.

    1. I need to send one value to Oracle on Unix from Oracle on Windows 2000
    2. In return I need to get a value from Oracle on Unix.
    3. Store the returned value in the local Oracle on Windows 2000.

    Can I do this just by writing some scripts ?

  2. #2
    Join Date
    Jul 2003
    look up dblink. this should solve your problems.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Apr 2002
    California, USA
    Take a look at this example Oracle DB Links on how to create and use Oracle db link.

    Once you have the link you can use any remote db table in your SQL queries and DML. No need to worry about the OS or location. The table apears to you transparently of its location.


    clio_usa - OCP 8/8i/9i

  4. #4
    Join Date
    Feb 2003

    Question Trading Values

    DBlink is a perfectly valid option and probably the easiest method.

    Another option is to use PL/SQL scripts and the DBMS_PIPE option
    to 'pipe' a value or values between the 2 DB's.

    You'd need to experiment a little to get this right so checkout the DBMS_PIPE
    documentation and see if this is better for you then the DBlink method.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts