Community archive

Ask something
Discussion Locked

Access to Oracle

0 helpful
1 reply

by shelby.wiles

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am trying to use a select query to pull information from two different Oracle databases. I am able to use the SQL @link to get the information with a passthrough query, but I need to be able to do this in a select query. Can anyone help me please!!!

1 reply

by joy.sheldon

If it's 7.3.4:
1)you need to be a user in both environments and have permission to access the tables you are referencing.
2)you also need to create(or if insufficient privileges-have your dba create) a database link (which is its own object)
3) Does your query exist in Oracle or are you using some tool to get there? If you are in Oracle, using a database link you can do something like this:
ie. select * from prod_schema.table
minus
select * from test_schema.table@other_db;
which would give you the differences between the same table on two databases (ie test and production)....
4)You also require the correct tnsnames information which can vary depending on your version of SQL*Net...again you may need to speak with your DBA...
Good Luck!
Joy

This discussion is closed to new replies.