[Home] [Help]
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')
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')
|
|
|
|