DBA Data[Home] [Help]
Skip to content

VIEW: SYS.KU$_ORACLE_SUPPLIED_OBJ_VIEW

Source

View Text - Preformatted

SELECT  type_name, owner_name, name
        FROM    sys.ku$_schemaobj_view
        WHERE   BITAND(flags, 4194304) = 4194304 AND
                owner_name NOT IN (SELECT UNIQUE n.name
                                   FROM   sys.ku_noexp_tab n
                                    WHERE n.obj_type = 'SCHEMA')
View Text - HTML Formatted

SELECT TYPE_NAME
, OWNER_NAME
, NAME
FROM SYS.KU$_SCHEMAOBJ_VIEW
WHERE BITAND(FLAGS
, 4194304) = 4194304 AND OWNER_NAME NOT IN (SELECT UNIQUE N.NAME
FROM SYS.KU_NOEXP_TAB N
WHERE N.OBJ_TYPE = 'SCHEMA')