Avatar of Member_2_2484401
Member_2_2484401
Flag for United States of America asked on

Quick and easy Oracle question from a long-term DB2 guy

Greetings, esteemed experts!

For decades, I've been a DB2 developer and DBA. I'm now being asked to write some queries for an existing Oracle database. Of course, I thought, "SQL is SQL. How hard can it be?"

But, unfortunately, I'm tripping up on (probably easy) problem. The SQL that I inherited from the previous developer includes access to "remote database" like this:

select <somestuff>
  from SomeSchema.SomeTable@adg

Open in new window


It looks simple enough, right?! But, when I run this query, it fails with a message that says "ORA-2019: connection description for remote database not found". I speculate that it has to do with the "@adg" at the end of the table-name, but I don't know what that refers to or how to point it correctly.

Does anybody have any suggestions?

Thanks in advance!
-- DaveSlash
Oracle Database

Avatar of undefined
Last Comment
Member_2_2484401

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
slightwv (䄆 Netminder)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Member_2_2484401

ASKER
Thanks, slightwv !

I checked the DB links in the logon schema and the table's schema (via Toad), and there are none ... which, I guess, explains why it couldn't find the one it was looking for. I removed the "@adg" part of the query, and it did come back with some data. So, I think that's all I really need.

Thanks, again!
DaveSlash
slightwv (䄆 Netminder)

Be careful by removing the link.  It must have been there for a reason.

Without a database link in the query, you might not be using the table you are supposed to be using.
Member_2_2484401

ASKER
Thanks!
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck