Toad World® Forums

DESC over database link


#1

Hello,

When I try to “describe” a table over a database link (e.g. as user scott: DESC dual@alink), I get the error:

Oracle Dictionary: DATABASE LINK SCOTT.alink not found


#2

Hi Dominique,

This bug will be fixed soon. Please check it in our next beta release. Thanks.

Gwen


#3

Still present in 1478…


#4

It seems to work fine in our internal build. Have you tried in SQL Plus to check if the dblink is ok?

Gwen


#5

Gwen,

When I select over the link, all is OK (see screenshot).
It’s not just this one link that fails when requesting a “describe”, BTW. They all do. And they succeed in SQL*Plus…


#6

Is it a public synonym, Dominique? I can reproduce the issue with a public synonym so hopefully it’s the underlying cause for you as well.

Gwen


#7

DUAL is (of course) a public synonym.
All the tables I tested at the remote databases also have a public synonym.

So, I have created a table at a remote database without a public synonym, but a describe of it over a link still fails (and a select from it works).

The database links themselves are public database links.


#8

Thanks for the info. This fix will be available in the next beta release.

Gwen


#9

Fixed in SQL Navigator 6.2 Beta Build 1486. Thx!


#10

Great to hear!