Hi Alan,

This query is bringing back a list of all tables, views, and synonyms to which the Oracle user account has access. (In your case, that's over 200,000.) This suggests that the Oracle account is way too privileged. 😉

If you know the target schema(s) of interest, add

and /*o1, o2*/.owner in ('SCHEMA1','SCHEMA2')

to the WHERE clauses to cut it down. The query is not efficiently written, but it does run 'as is' on my Oracle system. HTH