Oracle reports - multiple connections [message #79881] |
Sat, 20 July 2002 07:04 |
Vani Viswanathan
Messages: 4 Registered: July 2002
|
Junior Member |
|
|
Hi,
I have a query which will access tables in more than one database and display. When I run the query, it says table does not exist - because I am connected to DB1 and the error says table in the DB2 does not exist. How to have two connections at the same time and how to differentiate between those ?
Thanks
Vani
|
|
|
Re: Oracle reports - multiple connections [message #79890 is a reply to message #79881] |
Mon, 22 July 2002 00:07 |
katharina
Messages: 5 Registered: July 2002
|
Junior Member |
|
|
Hello vani!
I think the problems is that the user you are working with has not enough access rights to DB2. Give him some read or write access rights. When you are connected to DB1, call the different tables in your select statement by putting the database name in front of the table name. (db1.tablename1, db2.tablename2)
Greetz kat
|
|
|
|