some of the DBA_* data dictionary views are not appearing in the list populated by code assitent

[Karthi S]

Hi there,

I am using PLSQL developer 11.1 and I have access to view the data in some of the "dba_*" dictionary views.

for eg: in database(A) when i run "select * from dba_tables" i do see the data in SQL window, but i am not getting "dba_tables" populated in the list by code assistant when i type in "dba_"

But when i connect to another database (B), i do see "dba_tables" are populated when i type in "dba_".. not sure what is the difference.

can you please share your thoughts?

 

[Marco Kalter]

Perhaps you need to enable the "Use DBA views if available" preference from the Oracle / Options preference page?

 

[Karthi S]

Hi Marco

thanks for your response.

I have "use DBA views if available" is enabled, in fact in the same single instance of PLSQL Developer, when I connect to Database(A) - i dont see "dba_tables" populated by code assistant when type "dba_", but when i connect to database(B) from the same instance and trying "dba_" and that brings up "dba_tables" and other views that are accessible..

I doubt the way DBAs granted the access to my ID is different, but they are NOT interested in sharing that information..

so i am trying to find if any work around..

Thanks.

 

[Marco Kalter]

Can you check the CANames.sql file in the PL/SQL Developer installation directory? It contains the queries that are used to populate list when typing "dba_". Since DBA_VIEWS is a public synonym, it should be returned by the following query in the CANames.sql script:

select s.synonym_name as object_name, o.object_type
  from all_synonyms s, sys.all_objects o
 where s.owner in ('PUBLIC', sys_context('userenv', 'current_schema'))
   and o.owner = s.table_owner
   and o.object_name = s.table_name
   and o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')

 

[Karthi S]

Hi Marco,

When I tried that SQL in SQL window, I do see "dba_tables" in one database(B) and not in another database(A).