Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Question on DESCRIBE for synonyms.

503282Mar 31 2006 — edited Apr 3 2006
First 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 1 2006
Added on Mar 31 2006
2 comments
466 views