VIEW: SYS.KU_NOEXP_VIEW

Source

View Text - Preformatted

SELECT  decode(n.obj_type, 2, 'TABLE', 6, 'SEQUENCE', 110, 'XS_ACL',
                       'ERROR'),
                n.owner, n.name
        FROM    sys.noexp$ n
      UNION
        SELECT  k.obj_type, k.schema, k.name
        FROM    sys.ku_noexp_tab k

View Text - HTML Formatted

SELECT DECODE(N.OBJ_TYPE
, 2
, 'TABLE'
, 6
, 'SEQUENCE'
, 110
, 'XS_ACL'
, 'ERROR')
, N.OWNER
, N.NAME
FROM SYS.NOEXP$ N UNION SELECT K.OBJ_TYPE
, K.SCHEMA
, K.NAME
FROM SYS.KU_NOEXP_TAB K