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

VIEW: SYS.KU$_LOBINDEX_VIEW

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
OBJ_NUM NUMBER

SCHEMA_OBJ KU$_SCHEMAOBJ_T (2768)
TS_NAME VARCHAR2 (30)
BLOCKSIZE NUMBER

STORAGE KU$_STORAGE_T (512)
DEFERRED_STG KU$_DEFERRED_STG_T (552)
DATAOBJ_NUM NUMBER

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

SPARE3 NUMBER

SPARE4 VARCHAR2 (1000)
SPARE5 VARCHAR2 (1000)
SPARE6 VARCHAR2 (19)
Query Text

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


SELECT OBJ_NUM
,      SCHEMA_OBJ
,      TS_NAME
,      BLOCKSIZE
,      STORAGE
,      DEFERRED_STG
,      DATAOBJ_NUM
,      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
,      SPARE3
,      SPARE4
,      SPARE5
,      SPARE6
FROM SYS.KU$_LOBINDEX_VIEW;

Dependencies

[top of page]

SYS.KU$_LOBINDEX_VIEW references the following:

SchemaSYS
PL/SQL PackageDBMS_METADATA - show dependent code
TableIND$
TYPEKU$_DEFERRED_STG_T
ViewKU$_DEFERRED_STG_VIEW
TYPEKU$_LOBINDEX_T
TYPEKU$_SCHEMAOBJ_T
ViewKU$_SCHEMAOBJ_VIEW
TYPEKU$_STORAGE_T
ViewKU$_STORAGE_VIEW
PL/SQL PackageSTANDARD - show dependent code
TableTS$
SYS.KU$_LOBINDEX_VIEW is referenced by following:

SchemaSYS
ViewKU$_LOB_VIEW