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

Locked Post

New comments cannot be posted to this locked post.

Locked on May 1 2006

Added on Mar 31 2006

#sql-developer

2 comments

466 views