2 Replies Latest reply: Jul 17, 2013 4:06 AM by Trotty RSS

    4.0 EA1 - Find DB Object

    Trotty

      If i do a search for a table which i know exists in a specific schema and i have that specified schema ticked (It is not the schema i am logged on as, i'm logged in as APPS searching for object in HR) it is not found if All Objects Types are selected. If i untick DATABASE_LINK it finds the object, if i include it again the object is not found.

       

      I had APPS and HR schema ticked

      I was searching for PER_ALL_PEOPLE_F

       

      In my logging page I'm finding the following, not sure if related:

       

      SEVERE2910oracle.dbtools.parser.plsql.QueryORA-00942: table or view does not exist
      SEVERE29050826oracle.dbtools.parser.plsql.Queryselect null name, -1 LINE, -1 COL, null USAGE, case when obj.object_type like 'JAVA%' then 'JAVA' else obj.object_type end TYPE, OWNER, case when obj.object_type like 'JAVA%' then 'JAVA' else obj.object_type end OBJECT_TYPE, obj.OBJECT_NAME from sys.dba_objects obj where rownum <= 500 and obj.object_type != 'TABLE PARTITION' and obj.object_type != 'TABLE SUBPARTITION' and obj.object_type != 'JAVA CLASS' and object_name like :object_name and owner in ( :1 ) union all select null name, -1 LINE, -1 COL, null USAGE, 'MATERIALIZED VIEW LOG' TYPE, log_owner OWNER, 'MATERIALIZED VIEW LOG' OBJECT_TYPE, master||'('||LOG_TABLE||')' OBJECT_NAME from all_snapshot_logs where rownum <= 500 and log_owner in ( :2 ) and master like :master union select null name, -1 LINE, -1 COL, null USAGE, 'DATABASE LINK' TYPE, owner OWNER, 'DATABASE LINK' OBJECT_TYPE, db_link OBJECT_NAME from dba_db_links where rownum <= 500 and owner in ( :3 ) and db_link like :db_link