eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.KU$_ALL_INDEX_VIEW

Object Details

Object Name:	KU$_ALL_INDEX_VIEW
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
VERS_MAJOR	CHAR	(1)
VERS_MINOR	CHAR	(1)
OBJ_NUM	NUMBER
SCHEMA_OBJ	KU$_SCHEMAOBJ_T	(2768)
COL_LIST	KU$_INDEX_COL_LIST_T	(64)
TS_NAME	VARCHAR2	(30)
BLOCKSIZE	NUMBER
STORAGE	KU$_STORAGE_T	(512)
DEFERRED_STG	KU$_DEFERRED_STG_T	(552)
DATAOBJ_NUM	NUMBER
BASE_OBJ_NUM	NUMBER
BASE_OBJ	KU$_SCHEMAOBJ_T	(2768)
ANC_OBJ	KU$_SCHEMAOBJ_T	(2768)
INDMETHOD_NUM	NUMBER
INDTYPE_NAME	VARCHAR2	(128)
INDTYPE_OWNER	VARCHAR2	(128)
SECOBJS	KU$_DOMIDX_2NDTAB_LIST_T	(64)
PLSQL_CODE	KU$_DOMIDX_PLSQL_T	(64)
JIJOIN_TABS	KU$_JIJOIN_TABLE_LIST_T	(64)
JIJOIN	KU$_JIJOIN_LIST_T	(64)
COLS	NUMBER
PCT_FREE	NUMBER
INITRANS	NUMBER
MAXTRANS	NUMBER
PCT_THRES	NUMBER
TYPE_NUM	NUMBER
FLAGS	NUMBER
PROPERTY	NUMBER
BLEVEL	NUMBER
LEAFCNT	NUMBER
DISTKEY	NUMBER
LBLKKEY	NUMBER
DBLKKEY	NUMBER
CLUFAC	NUMBER
ANALYZETIME	VARCHAR2	(19)
SAMPLESIZE	NUMBER
ROWCNT	NUMBER
INTCOLS	NUMBER
DEGREE	NUMBER
INSTANCES	NUMBER
TRUNCCNT	NUMBER
NUMCOLSDEP	NUMBER
NUMKEYCOLS	NUMBER
PART_OBJ	KU$_IND_PARTOBJ_T	(64)
SPARE3	NUMBER
SPARE4	VARCHAR2	(1000)
SPARE5	VARCHAR2	(1000)
SPARE6	VARCHAR2	(19)
FOR_PKOID	NUMBER
FOR_REFPAR	NUMBER
OID_OR_SETID	NUMBER
BASE_PROPERTY	NUMBER
BASE_PROPERTY2	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT VERS_MAJOR
,      VERS_MINOR
,      OBJ_NUM
,      SCHEMA_OBJ
,      COL_LIST
,      TS_NAME
,      BLOCKSIZE
,      STORAGE
,      DEFERRED_STG
,      DATAOBJ_NUM
,      BASE_OBJ_NUM
,      BASE_OBJ
,      ANC_OBJ
,      INDMETHOD_NUM
,      INDTYPE_NAME
,      INDTYPE_OWNER
,      SECOBJS
,      PLSQL_CODE
,      JIJOIN_TABS
,      JIJOIN
,      COLS
,      PCT_FREE
,      INITRANS
,      MAXTRANS
,      PCT_THRES
,      TYPE_NUM
,      FLAGS
,      PROPERTY
,      BLEVEL
,      LEAFCNT
,      DISTKEY
,      LBLKKEY
,      DBLKKEY
,      CLUFAC
,      ANALYZETIME
,      SAMPLESIZE
,      ROWCNT
,      INTCOLS
,      DEGREE
,      INSTANCES
,      TRUNCCNT
,      NUMCOLSDEP
,      NUMKEYCOLS
,      PART_OBJ
,      SPARE3
,      SPARE4
,      SPARE5
,      SPARE6
,      FOR_PKOID
,      FOR_REFPAR
,      OID_OR_SETID
,      BASE_PROPERTY
,      BASE_PROPERTY2
FROM SYS.KU$_ALL_INDEX_VIEW;

Dependencies

[top of page]

SYS.KU$_ALL_INDEX_VIEW references the following:

SYS: CDEF$; DBMS_METADATA - show dependent code; DBMS_METADATA_UTIL - show dependent code; DUAL; IND$; KU$_DEFERRED_STG_T; KU$_DEFERRED_STG_VIEW; KU$_DOMIDX_2NDTAB_LIST_T; KU$_DOMIDX_2NDTAB_VIEW; KU$_DOMIDX_PLSQL_T; KU$_DOMIDX_PLSQL_VIEW; KU$_INDEX_COL_LIST_T; KU$_INDEX_COL_VIEW; KU$_INDEX_T; KU$_IND_COMPART_LIST_T; KU$_IND_PARTOBJ_T; KU$_IND_PARTOBJ_VIEW; KU$_IND_PART_LIST_T; KU$_IND_SUBPART_LIST_T; KU$_INSERT_TS_LIST_T; KU$_JIJOIN_LIST_T; KU$_JIJOIN_TABLE_LIST_T; KU$_JIJOIN_TABLE_VIEW; KU$_JIJOIN_VIEW; KU$_PART_COL_LIST_T; KU$_SCHEMAOBJ_T; KU$_SCHEMAOBJ_VIEW; KU$_STORAGE_T; KU$_STORAGE_VIEW; OBJ$; SESSION_ROLES; STANDARD - show dependent code; TAB$; TS$; USER$

SYS.KU$_ALL_INDEX_VIEW is referenced by following:

SYS: KU$_10_2_INDEX_VIEW; KU$_12_1_INDEX_VIEW; KU$_CONSTRAINT1_VIEW; KU$_INDEX_VIEW; KU$_M_VIEW_FH_VIEW; KU$_M_VIEW_H_VIEW; KU$_M_VIEW_IOT_VIEW; KU$_M_VIEW_PFH_VIEW; KU$_M_VIEW_PH_VIEW; KU$_M_VIEW_PIOT_VIEW; KU$_M_ZONEMAP_FH_VIEW; KU$_M_ZONEMAP_H_VIEW; KU$_M_ZONEMAP_IOT_VIEW; KU$_M_ZONEMAP_PFH_VIEW; KU$_M_ZONEMAP_PH_VIEW; KU$_M_ZONEMAP_PIOT_VIEW; KU$_ZM_VIEW_FH_VIEW; KU$_ZM_VIEW_H_VIEW; KU$_ZM_VIEW_IOT_VIEW; KU$_ZM_VIEW_PFH_VIEW; KU$_ZM_VIEW_PH_VIEW; KU$_ZM_VIEW_PIOT_VIEW