Question on DESCRIBE for synonyms.
503282Mar 31 2006 — edited Apr 3 2006First off I'm new to Oracle, being a MS SQL Server 2000 guy trying to be converted.
I've been given access to an Oracle database and subsequently been given access to two other databases via many synonyms. All the Oracle databases are running on servers running Unix. I'm running Oracle SQL Developer 1.0.0.14 on Windows 2000 version 5 SP 4.
Doing a DESC on a synonymn with no DB_LINK works fine. On those with a DB_LINK it has returned an error for every one I've tried.
I don't know if the synonym's are Public or Private. (or how to tell)
I don't know if the Tables they refer to are Partitioned or Unpartitioned.
Can someone explain why I might not be able to see the column structure for the synonym's please?
eg. DESC only works under these circumstances kind of answer is preferred.
Thanks for your time. TCD