Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2004
    Posts
    8

    Question Unanswered: sql query to select data from different physical oracle databases

    is there a way to get data from different databases on different machines using a single SQL script and without dblinks?

    i need this to basically import data from multiple oracle dbs to a single mysql db. i can write separate queries for separate databases to spool off separate files which i can load into separate tables in the mysql database.

    but

    what if i have just one table in the mysql database
    can i have one SQL query to do the above and create just one file?

    (dblinks not possible in mysql)

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    You will need to use dblinks. I imagine the way would be to build a view on one Oracle database that reads teh data from all the others using dblinks. Then your mySQL database just needs to connect to this one database and select from the view.

  3. #3
    Join Date
    Feb 2004
    Posts
    8
    Quote Originally Posted by andrewst
    You will need to use dblinks. I imagine the way would be to build a view on one Oracle database that reads teh data from all the others using dblinks. Then your mySQL database just needs to connect to this one database and select from the view.
    hmm not a bad suggestion
    but then if at any given point in time all the consolidated data i need
    is in one view on one of the oracle databases , why would i use mysql
    i mean i can generate reports from that view instead right?

    what do you think?

  4. #4
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Yes, I can't see any benefit in using mySQL!

  5. #5
    Join Date
    Feb 2004
    Posts
    8
    ok
    so there is no solution for this, for now

  6. #6
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    ... apart from the one I gave you? Your objection to that appears to be that it makes your mySQL database redundant, not that it will not work!

  7. #7
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Perhaps, on reflection, you have posted this question in the wrong forum: what you appear to need is a way to connect to many Oracle databases (simultaneously?) from mySQL. That would be best asked in a mySQL forum.

Posting Permissions

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