Rick Stagliano
Member
I can
Query Builder won't work in Oracle 10G rel 10.2.0.20
- Thread starter Rick Stagliano
- Start date
There are some performance problems for for the all_synonyms view in 10.2. See Oracle Metalink note 364822.1 (Selects Against ALL_SYNONYMS Perform Badly on 10g Release 10.2).
Rick Stagliano
Member
Thanks Marco,
Does this mean that you need to change code for 10.2
The query below works:
-----------------------------------------------
select object_name, owner object_owner, status, object_type, created, last_ddl_time
from sys.all_objects o1
where object_type = 'TABLE'
and (object_type != 'SYNONYM' or
owner = user or owner = 'PUBLIC') and
exists (select * from sys.all_objects o2
where o2.object_type in ('TABLE', 'VIEW') )
order by decode(owner, user, 0, 1),
owner,
object_name
Does this mean that you need to change code for 10.2
The query below works:
-----------------------------------------------
select object_name, owner object_owner, status, object_type, created, last_ddl_time
from sys.all_objects o1
where object_type = 'TABLE'
and (object_type != 'SYNONYM' or
owner = user or owner = 'PUBLIC') and
exists (select * from sys.all_objects o2
where o2.object_type in ('TABLE', 'VIEW') )
order by decode(owner, user, 0, 1),
owner,
object_name
We'll check it out.
Similar threads
