Hello, In my company we use the Oracle version 10g 10.2.0.2, and we are not obtaining to use the Query Reporter 2,5 or 3,0, in the option Query Builder, which had the BUG of version of the Oracle 10g in view ALL_OBJECTS, with forecast of correction in november/06.
One is about the impossibidade to open the tables list and views, when we select option ALL_OBJECTS, since we cannot in connecting them with the password of the Owner and using USER_OBJECTS.
Our DBA carried through monitoring of query carried through and as it is constructed today, really does not function. It does not obtain to use one another way to carry through query, that would be to create one another one view with synonymous ALL_OBJECTS, had the Allroud to have predetermined the name of the vision with owner SYS.
We use the PLSQL Developer 7, and in this OK, which had is functioning query to be different. The DBA, although to consider that this query is incorrect therefore it is using view DBA_OBJECTS, the alteration for reading of this view also would solve.
Necessary of its aid, so that it evaluates the possibility to liberate new version, modifying query carried through in the indicated point, or the the least removing the prefix of owner SYS to the front of the name of the view.
You it could verify with urgency?
Current version of query in the applicatory one:
select object_name, owner object_owner,
status, object_type, created, last_ddl_time
from sys.all_objects o1
where object_type = :object_type
and (object_type != 'SYNONYM'
or ( (owner = user or owner = 'PUBLIC')
and exists (select * from sys.all_objects o2,
sys.all_synonyms s2
where s2.owner = o1.owner
and s2.synonym_name = o1.object_name
and o2.owner = s2.table_owner
and o2.object_name = s2.table_name
and o2.object_type ='TABLE')) )
order by decode(owner, user, 0, 1), owner, object_name
DBA Suggested query version :
select object_name, owner object_owner,
status, object_type, created, last_ddl_time
from sys.dba_objects o1
where object_type = :object_type
and (object_type != 'SYNONYM'
or ( (owner = user or owner = 'PUBLIC')
and exists (select * from sys.dba_objects o2,
sys.dba_synonyms s2
where s2.owner = o1.owner
and s2.synonym_name = o1.object_name
and o2.owner = s2.table_owner
and o2.object_name = s2.table_name
and o2.object_type ='TABLE')) )
order by decode(owner, user, 0, 1), owner, object_name
Thanks!
