We are using sql navigator for Oracle.We have public synonyms for remote objects and public synonyms for objects in local database.
When expanding the objects "Public" schema, the columns of remote tables are not visible where as columns for loca tables can be seen.I was trrying to compare this with executing a DDL on remote object vs local object.However 'Desc' on either objects yield results.
Bookmarks