VIEW: SYS.EXU81OBJ

Source

View Text - Preformatted

SELECT  o$.OBJ#, o$.DATAOBJ#, o$.OWNER#, o$.NAME, o$.NAMESPACE,
                o$.SUBNAME, o$.TYPE#, o$.CTIME, o$.MTIME, o$.STIME, o$.STATUS,
                o$.REMOTEOWNER, o$.LINKNAME, o$.FLAGS, o$.OID$, o$.SPARE1,
                o$.SPARE2, o$.SPARE3, o$.SPARE4, o$.SPARE5, o$.SPARE6,
                o$.SIGNATURE, o$.SPARE7, o$.SPARE8, o$.SPARE9
        FROM    sys.obj$ o$, sys.user$ u$
        WHERE   BITAND(o$.flags, 16) != 16 AND
                /* Ignore recycle bin objects */
                BITAND(o$.flags, 128) != 128 AND
                o$.owner# = u$.user# AND
                u$.name 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',
                                'GSMADMIN_INTERNAL', 'GSMUSER', 'GSMCATUSER',
                                'ORDDATA', 'LOGSTDBY_ADMINISTRATOR')

View Text - HTML Formatted

SELECT O$.OBJ#
, O$.DATAOBJ#
, O$.OWNER#
, O$.NAME
, O$.NAMESPACE
, O$.SUBNAME
, O$.TYPE#
, O$.CTIME
, O$.MTIME
, O$.STIME
, O$.STATUS
, O$.REMOTEOWNER
, O$.LINKNAME
, O$.FLAGS
, O$.OID$
, O$.SPARE1
, O$.SPARE2
, O$.SPARE3
, O$.SPARE4
, O$.SPARE5
, O$.SPARE6
, O$.SIGNATURE
, O$.SPARE7
, O$.SPARE8
, O$.SPARE9
FROM SYS.OBJ$ O$
, SYS.USER$ U$
WHERE BITAND(O$.FLAGS
, 16) != 16 AND /* IGNORE RECYCLE BIN OBJECTS */ BITAND(O$.FLAGS
, 128) != 128 AND O$.OWNER# = U$.USER# AND U$.NAME 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'
, 'GSMADMIN_INTERNAL'
, 'GSMUSER'
, 'GSMCATUSER'
, 'ORDDATA'
, 'LOGSTDBY_ADMINISTRATOR')