This content has been marked as final. Show 2 replies
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:
|SEVERE||291||0||oracle.dbtools.parser.plsql.Query||ORA-00942: table or view does not exist|
|SEVERE||290||50826||oracle.dbtools.parser.plsql.Query||select 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|