Another thought. If you can connect to both using odbc and you have a MS tool like access or excell etc. Then you can grab from both tables using that MS tool.

Mark

________________________________

From: Aggarwal Amit (CEI) [mailto:oracledba-ezmlmshield-x41496734.[Email address protected]
Sent: Tue 8/31/2004 12:14 PM
To: LazyDBA Discussion
Subject: How to get data from Oracle and DB2 in a single SQL query



Hello

I have an Oracle Database and a DB2 database. I want to run a query connecting in Oracle database pulling some data from Oracle and some from DB2 in a single query. How can I do it.

Can I create a DB Link pointing to DB2. If not what would be a good way. I can connect to each database individually using ODBC but the problem is I can't connect to both databases together.

Thanks
Amit


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html




Oracle LazyDBA home page