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

Thread: Querying from 2 databases

  1. 10-14-2009, 10:15 PM #1
    rajesh_css
    rajesh_css is offline Junior Member
    Join Date
    Oct 2009
    Posts
    1

    Querying from 2 databases

    Hi

    I have two oracle databases db1 & db2 residing on the same server
    i need to write a query joining one table from db1 and other from db2
    how can i do this?
    Reply With Quote Reply With Quote
  2. 10-15-2009, 04:31 AM #2
    ales
    ales is offline Advisor
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    You need a database link.
    See http://download.oracle.com/docs/cd/B...n.htm#i1107516
    Ales
    The whole difference between a little boy and an adult man is the price of toys
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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