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

VIEW: SYS.KU$_IND_PART_VIEW

Object Details
Object Name: KU$_IND_PART_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

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

BASE_OBJ_NUM NUMBER

PART_NUM NUMBER

TAB_PART_NAME VARCHAR2 (128)
HIBOUNDLEN NUMBER

HIBOUNDVAL VARCHAR2 (4000)
FLAGS NUMBER

PCT_FREE NUMBER

PCT_THRES NUMBER

INITRANS NUMBER

MAXTRANS NUMBER

ANALYZETIME VARCHAR2 (19)
SAMPLESIZE NUMBER

ROWCNT NUMBER

BLEVEL NUMBER

LEAFCNT NUMBER

DISTKEY NUMBER

LBLKKEY NUMBER

DBLKKEY NUMBER

CLUFAC NUMBER

SPARE1 NUMBER

SPARE2 NUMBER

SPARE3 NUMBER

INCLCOL NUMBER

PARAMETERS VARCHAR2 (1000)
Query Text

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


SELECT OBJ_NUM
,      SCHEMA_OBJ
,      TS_NAME
,      BLOCKSIZE
,      DEFERRED_STG
,      STORAGE
,      DATAOBJ_NUM
,      BASE_OBJ_NUM
,      PART_NUM
,      TAB_PART_NAME
,      HIBOUNDLEN
,      HIBOUNDVAL
,      FLAGS
,      PCT_FREE
,      PCT_THRES
,      INITRANS
,      MAXTRANS
,      ANALYZETIME
,      SAMPLESIZE
,      ROWCNT
,      BLEVEL
,      LEAFCNT
,      DISTKEY
,      LBLKKEY
,      DBLKKEY
,      CLUFAC
,      SPARE1
,      SPARE2
,      SPARE3
,      INCLCOL
,      PARAMETERS
FROM SYS.KU$_IND_PART_VIEW;

Dependencies

[top of page]

SYS.KU$_IND_PART_VIEW references the following:

SchemaSYS
PL/SQL PackageDBMS_METADATA - show dependent code
PL/SQL PackageDBMS_METADATA_UTIL - show dependent code
TableIND$
TableINDPART$
TableINDPART_PARAM$
TYPEKU$_DEFERRED_STG_T
ViewKU$_DEFERRED_STG_VIEW
TYPEKU$_IND_PART_T
TYPEKU$_SCHEMAOBJ_T
ViewKU$_SCHEMAOBJ_VIEW
TYPEKU$_STORAGE_T
ViewKU$_STORAGE_VIEW
TableOBJ$
PL/SQL PackageSTANDARD - show dependent code
TableTABPART$
TableTS$
SYS.KU$_IND_PART_VIEW is referenced by following:

SchemaSYS
ViewKU$_IND_PARTOBJ_VIEW