Question on third party tool-SQL Navigator
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Question on third party tool-SQL Navigator

  1. #1
    Join Date
    Jun 2000
    Location
    Memphis,TN
    Posts
    30
    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.

    Any input will be of great help.

    thanks

  2. #2
    Join Date
    Feb 2001
    Posts
    180
    First try to describe the objects with the full name.
    When that does not work, it is a matter of rights.
    Regards
    Ben de Boer

  3. #3
    Join Date
    Jun 2000
    Location
    Memphis,TN
    Posts
    30
    The "Describe" works fine.It is the navigator which is not showing the columns when expanded.

  4. #4
    Join Date
    Feb 2001
    Posts
    180
    In that case contact your supplier, or go to the website of SQL Navigator and search if the problem is known there.
    Regards
    Ben de Boer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width