SQL Optimizer for Oracle 9.2.2
SELECT owner,
synonym_name,
table_owner,
table_name
FROM dba_synonyms dba_syns
WHERE table_owner = user
AND (NOT EXISTS – no target table/view
(SELECT 0
FROM user_views uv
WHERE uv.view_name = dba_syns.table_name
UNION
SELECT 0
FROM user_tables ut
WHERE ut.table_name = dba_syns.table_name
UNION
SELECT 0
FROM user_objects uo
WHERE uo.object_name = dba_syns.table_name)
OR NOT EXISTS – no grant for target table/view
(SELECT 0
FROM table_privileges tp
WHERE tp.grantee = dba_syns.owner
AND tp.table_name = dba_syns.table_name));
returns ORA-01039 while getting plan
The statement runs absolutely well when executed in TOAD for Oracle 12.12.
Any ideas?