VIEW: SYS.EXU9PTS

Source

View Text - Preformatted

SELECT  o$.name, o$.name, s$.name, s$.owner, s$.node,
                DECODE(o$.owner#, 1, 1, 0), uo$.name, o$.owner#, us$.user#,
                s$.obj#, o$.ctime
        FROM    sys.exu81obj o$, sys.syn$ s$, sys.user$ us$, sys.user$ uo$
        WHERE   s$.obj# = o$.obj# AND
                o$.owner# = uo$.user# AND
                s$.owner = us$.name(+) AND
                NVL(s$.owner, 'SYS') NOT IN
                   ('ORDSYS', 'MDSYS', 'CTXSYS', 'ORDPLUGINS', 'LBACSYS',
                    'XDB', 'SI_INFORMTN_SCHEMA', 'DIP',  'DBSNMP', 'EXFSYS',
                    'WMSYS','ORACLE_OCM', 'ANONYMOUS', 'XS$NULL',
                    'APPQOSSYS', 'OJVMSYS', 'SYSBACKUP', 'SYSDG', 'SYSKM',
                    'DVSYS', 'DVF', 'DBHADOOP', 'ORDDATA',
                    'GSMADMIN_INTERNAL', 'GSMUSER', 'GSMCATUSER',
                    'LOGSTDBY_ADMINISTRATOR', 'OLAPSYS', 'FLOWS_FILES',
                    'APEX_040200') AND
                o$.owner# = 1 AND
                EXISTS (
                    SELECT obj#
                    FROM sys.obj$ e
                    WHERE e.name = s$.name AND
                          e.owner# = us$.user# AND
                          e.type# = 13 )

View Text - HTML Formatted

SELECT O$.NAME
, O$.NAME
, S$.NAME
, S$.OWNER
, S$.NODE
, DECODE(O$.OWNER#
, 1
, 1
, 0)
, UO$.NAME
, O$.OWNER#
, US$.USER#
, S$.OBJ#
, O$.CTIME
FROM SYS.EXU81OBJ O$
, SYS.SYN$ S$
, SYS.USER$ US$
, SYS.USER$ UO$
WHERE S$.OBJ# = O$.OBJ# AND O$.OWNER# = UO$.USER# AND S$.OWNER = US$.NAME(+) AND NVL(S$.OWNER
, 'SYS') NOT IN ('ORDSYS'
, 'MDSYS'
, 'CTXSYS'
, 'ORDPLUGINS'
, 'LBACSYS'
, 'XDB'
, 'SI_INFORMTN_SCHEMA'
, 'DIP'
, 'DBSNMP'
, 'EXFSYS'
, 'WMSYS'
, 'ORACLE_OCM'
, 'ANONYMOUS'
, 'XS$NULL'
, 'APPQOSSYS'
, 'OJVMSYS'
, 'SYSBACKUP'
, 'SYSDG'
, 'SYSKM'
, 'DVSYS'
, 'DVF'
, 'DBHADOOP'
, 'ORDDATA'
, 'GSMADMIN_INTERNAL'
, 'GSMUSER'
, 'GSMCATUSER'
, 'LOGSTDBY_ADMINISTRATOR'
, 'OLAPSYS'
, 'FLOWS_FILES'
, 'APEX_040200') AND O$.OWNER# = 1 AND EXISTS ( SELECT OBJ#
FROM SYS.OBJ$ E
WHERE E.NAME = S$.NAME AND E.OWNER# = US$.USER# AND E.TYPE# = 13 )