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:
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!