select s.obj#, s.secobj#, value(o)
from sys.ku$_schemaobj_view o, sys.secobj$ s
where o.obj_num = s.secobj#
and o.type_num = 2
and dbms_metadata.oktoexp_2ndary_table(s.secobj#)!= 0
View Text - HTML Formatted
SELECT S.OBJ# , S.SECOBJ# , VALUE(O)
FROM SYS.KU$_SCHEMAOBJ_VIEW O , SYS.SECOBJ$ S
WHERE O.OBJ_NUM = S.SECOBJ#
AND O.TYPE_NUM = 2
AND DBMS_METADATA.OKTOEXP_2NDARY_TABLE(S.SECOBJ#)!= 0