[Home] [Help] [Dependency Information]
Object Name: | KU$_INDEX_VIEW |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 |
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$_INDEX_VIEW;
SYS.KU$_INDEX_VIEW is not referenced by any database object
|
|
|