[Home] [Help]
[Dependency Information]
VIEW: SYS.KU$_SCHEMAOBJ_VIEW
Object Details
Object Name: | KU$_SCHEMAOBJ_VIEW |
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
OBJ_NUM |
NUMBER |
|
|
|
DATAOBJ_NUM |
NUMBER |
|
|
|
OWNER_NUM |
NUMBER |
|
|
|
OWNER_NAME |
VARCHAR2 |
(128) |
|
|
NAME |
VARCHAR2 |
(128) |
|
|
NAMESPACE |
NUMBER |
|
|
|
SUBNAME |
VARCHAR2 |
(128) |
|
|
TYPE_NUM |
NUMBER |
|
|
|
TYPE_NAME |
VARCHAR2 |
(45) |
|
|
CTIME |
VARCHAR2 |
(19) |
|
|
MTIME |
VARCHAR2 |
(19) |
|
|
STIME |
VARCHAR2 |
(19) |
|
|
STATUS |
NUMBER |
|
|
|
REMOTEOWNER |
VARCHAR2 |
(128) |
|
|
LINKNAME |
VARCHAR2 |
(128) |
|
|
FLAGS |
NUMBER |
|
|
|
OID |
RAW |
(16) |
|
|
SPARE1 |
NUMBER |
|
|
|
SPARE2 |
NUMBER |
|
|
|
SPARE3 |
NUMBER |
|
|
|
SPARE4 |
VARCHAR2 |
(1000) |
|
|
SPARE5 |
VARCHAR2 |
(1000) |
|
|
SPARE6 |
VARCHAR2 |
(19) |
|
|
OWNER_NAME2 |
VARCHAR2 |
(128) |
|
|
SIGNATURE |
RAW |
(16) |
|
|
SPARE7 |
NUMBER |
|
|
|
SPARE8 |
NUMBER |
|
|
|
SPARE9 |
NUMBER |
|
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT OBJ_NUM
, DATAOBJ_NUM
, OWNER_NUM
, OWNER_NAME
, NAME
, NAMESPACE
, SUBNAME
, TYPE_NUM
, TYPE_NAME
, CTIME
, MTIME
, STIME
, STATUS
, REMOTEOWNER
, LINKNAME
, FLAGS
, OID
, SPARE1
, SPARE2
, SPARE3
, SPARE4
, SPARE5
, SPARE6
, OWNER_NAME2
, SIGNATURE
, SPARE7
, SPARE8
, SPARE9
FROM SYS.KU$_SCHEMAOBJ_VIEW;
Dependencies
[top of page]
SYS.KU$_SCHEMAOBJ_VIEW references the following:
-
SYS
-
KU$_SCHEMAOBJ_T
-
OBJ$
-
STANDARD
- show dependent code
-
USER$
SYS.KU$_SCHEMAOBJ_VIEW is referenced by following:
-
SYS
-
KU$_10_1_IND_STATS_VIEW
-
KU$_10_1_PIND_STATS_VIEW
-
KU$_10_1_PTAB_STATS_VIEW
-
KU$_10_1_SPIND_STATS_VIEW
-
KU$_10_1_TAB_ONLY_STATS_VIEW
-
KU$_10_1_TAB_STATS_VIEW
-
KU$_10_2_FHTABLE_VIEW
-
KU$_10_2_IND_STATS_VIEW
-
KU$_10_2_STRMCOLTYPE_VIEW
-
KU$_10_2_STRMSUBCOLTYPE_VIEW
-
KU$_10_2_STRMTABLE_VIEW
-
KU$_10_2_TAB_STATS_VIEW
-
KU$_11_2_IND_STATS_VIEW
-
KU$_11_2_TAB_STATS_VIEW
-
KU$_2ND_TABLE_OBJNUM_VIEW
-
KU$_ACPTABLE_VIEW
-
KU$_ALL_INDEX_VIEW
-
KU$_ASSOC_VIEW
-
KU$_AUDIT_OBJ_BASE_VIEW
-
KU$_AUDIT_POLICY_ENABLE_VIEW
-
KU$_AUDIT_POLICY_VIEW
-
KU$_CLSTCOL_VIEW
-
KU$_CLSTJOIN_VIEW
-
KU$_CLUSTER_VIEW
-
KU$_CONSTRAINT2_VIEW
-
KU$_CONSTRAINT_VIEW
-
KU$_CONTEXT_VIEW
-
KU$_CREDENTIAL_VIEW
-
KU$_DEPTABLE_OBJNUM_VIEW
-
KU$_DIMENSION_VIEW
-
KU$_DIRECTORY_VIEW
-
KU$_DOMIDX_2NDTAB_VIEW
-
KU$_DOMIDX_OBJNUM_VIEW
-
KU$_EQNTABLE_DATA_VIEW
-
KU$_FGA_POLICY_VIEW
-
KU$_FHTABLE_VIEW
-
KU$_HTABLE_DATA_VIEW
-
KU$_HTABLE_VIEW
-
KU$_HTPART_DATA_VIEW
-
KU$_HTSPART_DATA_VIEW
-
KU$_IDCOL_SEQ_VIEW
-
KU$_IDENTITY_COLOBJ_VIEW
-
KU$_INDARRAYTYPE_VIEW
-
KU$_INDEXOP_VIEW
-
KU$_INDEXTYPE_VIEW
-
KU$_IND_COMPART_VIEW
-
KU$_IND_PART_VIEW
-
KU$_IND_STATS_VIEW
-
KU$_IND_SUBNAME_VIEW
-
KU$_IND_SUBPART_VIEW
-
KU$_INSTANCE_CALLOUT_VIEW
-
KU$_IOTABLE_DATA_VIEW
-
KU$_IOTABLE_VIEW
-
KU$_IOTPART_DATA_VIEW
-
KU$_JAVA_CLASS_VIEW
-
KU$_JAVA_OBJNUM_VIEW
-
KU$_JAVA_RESOURCE_VIEW
-
KU$_JAVA_SOURCE_VIEW
-
KU$_JIJOIN_TABLE_VIEW
-
KU$_LOBCOMPPART_VIEW
-
KU$_LOBFRAGINDEX_VIEW
-
KU$_LOBFRAG_VIEW
-
KU$_LOBINDEX_VIEW
-
KU$_LOB_VIEW
-
KU$_MONITOR_VIEW
-
KU$_MV_DEPTBL_OBJNUM_VIEW
-
KU$_NIOTABLE_DATA_VIEW
-
KU$_NTABLE_DATA_VIEW
-
KU$_NTABLE_OBJNUM_VIEW
-
KU$_NTPART_VIEW
-
KU$_NT_PARENT_VIEW
-
KU$_OPANCILLARY_VIEW
-
KU$_OPERATOR_VIEW
-
KU$_OPTION_OBJNUM_VIEW
-
KU$_ORACLE_SUPPLIED_OBJ_VIEW
-
KU$_PARTLOB_VIEW
-
KU$_PFHTABLE_VIEW
-
KU$_PHTABLE_VIEW
-
KU$_PIOTABLE_VIEW
-
KU$_PIOTLOBFRAG_VIEW
-
KU$_PIOT_PART_VIEW
-
KU$_PKREF_CONSTRAINT_VIEW
-
KU$_POST_DATA_TABLE_VIEW
-
KU$_POST_TABLE_VIEW
-
KU$_PRE_TABLE_VIEW
-
KU$_PROCACT_INSTANCE_VIEW
-
KU$_PROCDEPOBJ_AUDIT_VIEW
-
KU$_PROCDEPOBJ_GRANT_VIEW
-
KU$_PROCDEPOBJ_VIEW
-
KU$_PROCOBJ_AUDIT_VIEW
-
KU$_PROCOBJ_GRANT_VIEW
-
KU$_PROCOBJ_OBJNUM_VIEW
-
KU$_PROCOBJ_VIEW
-
KU$_QTRANS_VIEW
-
KU$_QUEUES_VIEW
-
KU$_QUEUE_TABLE_VIEW
-
KU$_RADM_POLICY_VIEW
-
KU$_REF_CONSTRAINT_VIEW
-
KU$_RLS_POLICY_OBJNUM_VIEW
-
KU$_RMGR_CONSUMER_VIEW
-
KU$_RMGR_PLAN_DIRECT_VIEW
-
KU$_RMGR_PLAN_VIEW
-
KU$_SCHEMAOBJNUM_VIEW
-
KU$_SEQUENCE_VIEW
-
KU$_STRMCOLTYPE_VIEW
-
KU$_STRMSUBCOLTYPE_VIEW
-
KU$_STRMTABLE_VIEW
-
KU$_SUBCOLTYPE_VIEW
-
KU$_SUBLOBFRAGINDEX_VIEW
-
KU$_SUBLOBFRAG_VIEW
-
KU$_SWITCH_COMPILER_VIEW
-
KU$_TABCLST_VIEW
-
KU$_TABCLUSTER_VIEW
-
KU$_TABLE_OBJNUM_VIEW
-
KU$_TAB_COMPART_VIEW
-
KU$_TAB_PART_VIEW
-
KU$_TAB_STATS_VIEW
-
KU$_TAB_SUBNAME_VIEW
-
KU$_TAB_SUBPART_VIEW
-
KU$_TRIGGER_VIEW
-
KU$_TTSP_INDPARTVIEW
-
KU$_TTSP_INDSUBPARTVIEW
-
KU$_TTS_PARTLOBVIEW
-
KU$_TTS_SUBPARTLOBVIEW
-
KU$_TTS_TABPARTVIEW
-
KU$_TTS_TABSUBPARTVIEW
-
KU$_TTS_TABVIEW
-
KU$_TYPE_VIEW
-
KU$_USER_PREF_STATS_VIEW
-
KU$_XDB_NTABLE_OBJNUM_VIEW
-
KU$_XMLSCHEMA_TYPES_VIEW
-
KU$_XSRLS_POLICY_VIEW