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

VIEW: SYS.KU$_IND_SUBPART_VIEW

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

POBJ_NUM NUMBER

SUBPART_NUM NUMBER

TAB_SUBPART_NAME VARCHAR2 (128)
FLAGS NUMBER

PCT_FREE 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

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
,      POBJ_NUM
,      SUBPART_NUM
,      TAB_SUBPART_NAME
,      FLAGS
,      PCT_FREE
,      INITRANS
,      MAXTRANS
,      ANALYZETIME
,      SAMPLESIZE
,      ROWCNT
,      BLEVEL
,      LEAFCNT
,      DISTKEY
,      LBLKKEY
,      DBLKKEY
,      CLUFAC
,      SPARE1
,      SPARE2
,      SPARE3
FROM SYS.KU$_IND_SUBPART_VIEW;

Dependencies

[top of page]

SYS.KU$_IND_SUBPART_VIEW references the following:

SchemaSYS
PL/SQL PackageDBMS_METADATA - show dependent code
TableIND$
TableINDCOMPART$
TableINDSUBPART$
TYPEKU$_DEFERRED_STG_T
ViewKU$_DEFERRED_STG_VIEW
TYPEKU$_IND_SUBPART_T
TYPEKU$_SCHEMAOBJ_T
ViewKU$_SCHEMAOBJ_VIEW
TYPEKU$_STORAGE_T
ViewKU$_STORAGE_VIEW
TableOBJ$
PL/SQL PackageSTANDARD - show dependent code
TableTABCOMPART$
TableTABSUBPART$
TableTS$
SYS.KU$_IND_SUBPART_VIEW is referenced by following:

SchemaSYS
ViewKU$_IND_COMPART_VIEW