VIEW: SYS.KU$_SCHEMAOBJ_VIEW

Source

View Text - Preformatted

select o.obj#, o.dataobj#, o.owner#, u.name, o.name, o.namespace, o.subname,
         o.type#,
         -- translate type# to name: type# values are defined in kgl.h
         decode(o.type#,
                 0, 'CURSOR',                    1, 'INDEX',
                 2, 'TABLE',                     3, 'CLUSTER',
                 4, 'VIEW',                      5, 'SYNONYM',
                 6, 'SEQUENCE',                  7, 'PROCEDURE',
                 8, 'FUNCTION',                  9, 'PACKAGE',
                11, 'PACKAGE_BODY',             12, 'TRIGGER',
                13, 'TYPE',                     14, 'TYPE_BODY',
                15, 'OBJECT',                   16, 'USER',
                17, 'LINK',                     18, 'PIPE',
                19, 'TABLE PARTITION',          20, 'INDEX PARTITION',
                21, 'LOB',                      22, 'LIBRARY',
                23, 'DIRECTORY',                24, 'QUEUE',
                25, 'IOT',                      26, 'REPLICATION OBJECT GROUP',
                27, 'REPLICATION PROPAGATOR',   28, 'JAVA_SOURCE',
                29, 'JAVA_CLASS',               30, 'JAVA_RESOURCE',
                31, 'JAVA JAR',                 32, 'INDEXTYPE',
                33, 'OPERATOR',                 34, 'TABLE SUBPARTITION',
                35, 'INDEX SUBPARTITION',       36, 'SERVER-SIDE REPAPI',
                37, 'REPLICATION INTERNAL PACKAGE',
                38, 'CONTEXT POLICY OBJECT',
                39, 'PUB_SUB INTERNAL INFORMATION',
                40, 'LOB PARTITION',            41, 'LOB SUBPARTITION',
                42, 'SUMMARY',                  43, 'DIMENSION',
                44, 'CONTEXT',                  45, 'OUTLINE',
                46, 'RULESET OBJECT',           47, 'SCHEDULER PLAN',
                48, 'SCHEDULER CLASS',          49, 'PENDING SCHEDULER PLAN',
                50, 'PENDING SCHEDULER CLASS',  51, 'SUBSCRIPTION INFORMATION',
                52, 'LOCATION INFORMATION',     53, 'REMOTE OBJECTS INFO',
                54, 'REPAPI SNAPSHOT METADATA', 55, 'IFS DATA',
                56, 'JAVA SHARED DATA',         57, 'SECURITY PROFILE',
                58, 'TRANSFORMATION',           59, 'RULE',
                60, 'CAPTURE PROCESS',          61, 'APPLY PROCESS',
                62, 'RULE EVALUATION CONTEXT',  63, 'LOG-BASED REPL SOURCE',
                64, 'STREAM DDL',               65, 'KGL TEST',
                66, 'SCHEDULER JOB',            67, 'SCHEDULER PROGRAM',
                68, 'SCHEDULER CLASS',          69, 'SCHEDULER WINDOW',
                70, 'MULTI-VERSIONED OBJECT',   71, 'SCHEDULER JOB SLAVE',
                72, 'SCHEDULER WINDOW GROUP',   73, 'CDC CHANGE SET',
                74, 'SCHEDULER SCHEDULE',       75, 'SQL TUNING BASE',
                76, 'HINTSET',                  77, 'SCHEDULER ATTRIBUTES',
                78, 'RESOURCE MANAGER CDB PLAN',
                79, 'SCHEDULER JOB CHAIN',      80, 'STRACH PAD',
                81, 'STREAMS FILE GROUP',       82, 'MINING MODEL',
                83, 'SCHEDULER EVENT QUEUE INFO',
                84, 'LIGHT WEIGHT SESSION',     85, 'DATA SECURITY DOCUMENT',
                86, 'SECURITY CLASS',           87, 'ASSEMBLY',
                88, 'STUB',                     89, 'LIGHTWEIGHT JOBS',
                90, 'CREDENTIAL',               91, 'REMOTE OBJECT REFERENCE',
                92, 'OLAP CUBE DIMENSION',      93, 'OLAP CUBE',
                94, 'OLAP MEASURE FOLDER',      95, 'OLAP CUBE BUILD PROCESS',
                96, 'STREAM PROPAGATION',       97, 'FUSION XS PARAMETERS',
                98, 'XDB REPOSITORY',           99, 'OBJECT ID',
                100, 'SCHEDULER FILE WATCHER',
                101, 'JOB SCHEDULER NAMED DESTINATION',
                102, 'CURSOR STATS',            103, 'TEXT MVDATA CACHE ',
                104, 'TEXT MVDATA -M    ',      105, 'TEXT MVDATA -F    ',
                106, 'TABLE-INDEX PARTITION CACHE',
                107, 'SPATIAL INDEX METADATA',
                108, 'FUSION XS NAMESPACE TEMPLATES',
                109, 'FUSION XS SECURITY CLASS',
                110, 'FUSION SECURITY ACL',     111, 'PLUGGABLE DATABASE',
                112, 'SPATIAL GEOM METADATA',   113, 'SPATIAL SRID METADATA',
                114, 'SQL TRANSLATION PROFILE', 115, 'AUDIT POLICY',
                116, 'SPATIAL FEATURE USAGE',
                117, 'SPATIAL CRS DIMENSION METADATA',
                118, 'SCHEDULER IN-MEMORY JOBS',
                119, 'OLS ILABELS',
                120, 'OLS GROUP NUMBER TO SHORT NAME MAPPINGS',
                121, 'OLS GROUP SHORT NAME TO NUMBER MAPPINGS',
                122, 'OLS COMPARTMENT NUMBER TO SHORT NAME MAPPINGS',
                123, 'OLS COMPARTMENT SHORT NAME TO NUMBER MAPPINGS',
                124, 'OLS LEVEL NUMBER TO SHORT NAME MAPPINGS',
                125, 'OLS LEVEL SHORT NAME TO NUMBER MAPPINGS',
                126, 'OPTIMIZER FINDING',       127, 'OPTIMIZER DIRECTIVE OWNER',
                128, 'OLS USERS',               129, 'DATABASE VAULT RULE',
                130, 'DATABASE VAULT RULE SET',
                131, 'LABEL SECURITY POLICY-TABLE CACHE',
                132, 'LABEL SECURITY LABEL-PID CACHE',
                133, 'OLS READ CONTROL RELATED CACHE',
                134, 'OLS$AUDIT OPTIONS',       135, 'USER PRIVILEGE',
                136, 'SCHEDULER RESOURCE CONSTRAINT',
                137, 'QUEUE DURABLE SUBSCRIBERS',
                     'ERROR'),
         to_char(o.ctime,'YYYY-MM-DD HH24:MI:SS'),
         to_char(o.mtime,'YYYY-MM-DD HH24:MI:SS'),
         to_char(o.stime,'YYYY-MM-DD HH24:MI:SS'),
         o.status, o.remoteowner,
         o.linkname, o.flags, o.oid$,
         o.spare1, o.spare2, o.spare3,
         o.spare4, o.spare5, to_char(o.spare6,'YYYY/MM/DD HH24:MI:SS'),
         case when (o.spare3 > 0) then
             (select u.name from user$ u where o.spare3 = u.user#)
         else null
         end,
  
         o.signature, o.spare7, o.spare8, o.spare9
  
  from obj$ o, user$ u
  where o.owner# = u.user#
  

View Text - HTML Formatted

SELECT O.OBJ#
, O.DATAOBJ#
, O.OWNER#
, U.NAME
, O.NAME
, O.NAMESPACE
, O.SUBNAME
, O.TYPE#
, -- TRANSLATE TYPE# TO NAME: TYPE# VALUES ARE DEFINED IN KGL.H DECODE(O.TYPE#
, 0
, 'CURSOR'
, 1
, 'INDEX'
, 2
, 'TABLE'
, 3
, 'CLUSTER'
, 4
, 'VIEW'
, 5
, 'SYNONYM'
, 6
, 'SEQUENCE'
, 7
, 'PROCEDURE'
, 8
, 'FUNCTION'
, 9
, 'PACKAGE'
, 11
, 'PACKAGE_BODY'
, 12
, 'TRIGGER'
, 13
, 'TYPE'
, 14
, 'TYPE_BODY'
, 15
, 'OBJECT'
, 16
, 'USER'
, 17
, 'LINK'
, 18
, 'PIPE'
, 19
, 'TABLE PARTITION'
, 20
, 'INDEX PARTITION'
, 21
, 'LOB'
, 22
, 'LIBRARY'
, 23
, 'DIRECTORY'
, 24
, 'QUEUE'
, 25
, 'IOT'
, 26
, 'REPLICATION OBJECT GROUP'
, 27
, 'REPLICATION PROPAGATOR'
, 28
, 'JAVA_SOURCE'
, 29
, 'JAVA_CLASS'
, 30
, 'JAVA_RESOURCE'
, 31
, 'JAVA JAR'
, 32
, 'INDEXTYPE'
, 33
, 'OPERATOR'
, 34
, 'TABLE SUBPARTITION'
, 35
, 'INDEX SUBPARTITION'
, 36
, 'SERVER-SIDE REPAPI'
, 37
, 'REPLICATION INTERNAL PACKAGE'
, 38
, 'CONTEXT POLICY OBJECT'
, 39
, 'PUB_SUB INTERNAL INFORMATION'
, 40
, 'LOB PARTITION'
, 41
, 'LOB SUBPARTITION'
, 42
, 'SUMMARY'
, 43
, 'DIMENSION'
, 44
, 'CONTEXT'
, 45
, 'OUTLINE'
, 46
, 'RULESET OBJECT'
, 47
, 'SCHEDULER PLAN'
, 48
, 'SCHEDULER CLASS'
, 49
, 'PENDING SCHEDULER PLAN'
, 50
, 'PENDING SCHEDULER CLASS'
, 51
, 'SUBSCRIPTION INFORMATION'
, 52
, 'LOCATION INFORMATION'
, 53
, 'REMOTE OBJECTS INFO'
, 54
, 'REPAPI SNAPSHOT METADATA'
, 55
, 'IFS DATA'
, 56
, 'JAVA SHARED DATA'
, 57
, 'SECURITY PROFILE'
, 58
, 'TRANSFORMATION'
, 59
, 'RULE'
, 60
, 'CAPTURE PROCESS'
, 61
, 'APPLY PROCESS'
, 62
, 'RULE EVALUATION CONTEXT'
, 63
, 'LOG-BASED REPL SOURCE'
, 64
, 'STREAM DDL'
, 65
, 'KGL TEST'
, 66
, 'SCHEDULER JOB'
, 67
, 'SCHEDULER PROGRAM'
, 68
, 'SCHEDULER CLASS'
, 69
, 'SCHEDULER WINDOW'
, 70
, 'MULTI-VERSIONED OBJECT'
, 71
, 'SCHEDULER JOB SLAVE'
, 72
, 'SCHEDULER WINDOW GROUP'
, 73
, 'CDC CHANGE SET'
, 74
, 'SCHEDULER SCHEDULE'
, 75
, 'SQL TUNING BASE'
, 76
, 'HINTSET'
, 77
, 'SCHEDULER ATTRIBUTES'
, 78
, 'RESOURCE MANAGER CDB PLAN'
, 79
, 'SCHEDULER JOB CHAIN'
, 80
, 'STRACH PAD'
, 81
, 'STREAMS FILE GROUP'
, 82
, 'MINING MODEL'
, 83
, 'SCHEDULER EVENT QUEUE INFO'
, 84
, 'LIGHT WEIGHT SESSION'
, 85
, 'DATA SECURITY DOCUMENT'
, 86
, 'SECURITY CLASS'
, 87
, 'ASSEMBLY'
, 88
, 'STUB'
, 89
, 'LIGHTWEIGHT JOBS'
, 90
, 'CREDENTIAL'
, 91
, 'REMOTE OBJECT REFERENCE'
, 92
, 'OLAP CUBE DIMENSION'
, 93
, 'OLAP CUBE'
, 94
, 'OLAP MEASURE FOLDER'
, 95
, 'OLAP CUBE BUILD PROCESS'
, 96
, 'STREAM PROPAGATION'
, 97
, 'FUSION XS PARAMETERS'
, 98
, 'XDB REPOSITORY'
, 99
, 'OBJECT ID'
, 100
, 'SCHEDULER FILE WATCHER'
, 101
, 'JOB SCHEDULER NAMED DESTINATION'
, 102
, 'CURSOR STATS'
, 103
, 'TEXT MVDATA CACHE '
, 104
, 'TEXT MVDATA -M '
, 105
, 'TEXT MVDATA -F '
, 106
, 'TABLE-INDEX PARTITION CACHE'
, 107
, 'SPATIAL INDEX METADATA'
, 108
, 'FUSION XS NAMESPACE TEMPLATES'
, 109
, 'FUSION XS SECURITY CLASS'
, 110
, 'FUSION SECURITY ACL'
, 111
, 'PLUGGABLE DATABASE'
, 112
, 'SPATIAL GEOM METADATA'
, 113
, 'SPATIAL SRID METADATA'
, 114
, 'SQL TRANSLATION PROFILE'
, 115
, 'AUDIT POLICY'
, 116
, 'SPATIAL FEATURE USAGE'
, 117
, 'SPATIAL CRS DIMENSION METADATA'
, 118
, 'SCHEDULER IN-MEMORY JOBS'
, 119
, 'OLS ILABELS'
, 120
, 'OLS GROUP NUMBER TO SHORT NAME MAPPINGS'
, 121
, 'OLS GROUP SHORT NAME TO NUMBER MAPPINGS'
, 122
, 'OLS COMPARTMENT NUMBER TO SHORT NAME MAPPINGS'
, 123
, 'OLS COMPARTMENT SHORT NAME TO NUMBER MAPPINGS'
, 124
, 'OLS LEVEL NUMBER TO SHORT NAME MAPPINGS'
, 125
, 'OLS LEVEL SHORT NAME TO NUMBER MAPPINGS'
, 126
, 'OPTIMIZER FINDING'
, 127
, 'OPTIMIZER DIRECTIVE OWNER'
, 128
, 'OLS USERS'
, 129
, 'DATABASE VAULT RULE'
, 130
, 'DATABASE VAULT RULE SET'
, 131
, 'LABEL SECURITY POLICY-TABLE CACHE'
, 132
, 'LABEL SECURITY LABEL-PID CACHE'
, 133
, 'OLS READ CONTROL RELATED CACHE'
, 134
, 'OLS$AUDIT OPTIONS'
, 135
, 'USER PRIVILEGE'
, 136
, 'SCHEDULER RESOURCE CONSTRAINT'
, 137
, 'QUEUE DURABLE SUBSCRIBERS'
, 'ERROR')
, TO_CHAR(O.CTIME
, 'YYYY-MM-DD HH24:MI:SS')
, TO_CHAR(O.MTIME
, 'YYYY-MM-DD HH24:MI:SS')
, TO_CHAR(O.STIME
, 'YYYY-MM-DD HH24:MI:SS')
, O.STATUS
, O.REMOTEOWNER
, O.LINKNAME
, O.FLAGS
, O.OID$
, O.SPARE1
, O.SPARE2
, O.SPARE3
, O.SPARE4
, O.SPARE5
, TO_CHAR(O.SPARE6
, 'YYYY/MM/DD HH24:MI:SS')
, CASE WHEN (O.SPARE3 > 0) THEN (SELECT U.NAME
FROM USER$ U
WHERE O.SPARE3 = U.USER#) ELSE NULL END
, O.SIGNATURE
, O.SPARE7
, O.SPARE8
, O.SPARE9
FROM OBJ$ O
, USER$ U
WHERE O.OWNER# = U.USER#