DBA Data[Home] [Help]

VIEW: SYS.KU$_DOMIDX_2NDTAB_VIEW

Source

View Text - Preformatted

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