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

VIEW: SYS.KU$_PIOT_PART_VIEW

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

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

BASE_OBJ_NUM NUMBER

PART_NUM NUMBER

HIBOUNDLEN NUMBER

HIBOUNDVAL VARCHAR2 (4000)
LOBS KU$_LOBFRAG_LIST_T (64)
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

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
,      BASE_OBJ_NUM
,      PART_NUM
,      HIBOUNDLEN
,      HIBOUNDVAL
,      LOBS
,      FLAGS
,      PCT_FREE
,      PCT_THRES
,      INITRANS
,      MAXTRANS
,      ANALYZETIME
,      SAMPLESIZE
,      ROWCNT
,      BLEVEL
,      LEAFCNT
,      DISTKEY
,      LBLKKEY
,      DBLKKEY
,      CLUFAC
,      SPARE1
,      SPARE2
,      SPARE3
,      INCLCOL
FROM SYS.KU$_PIOT_PART_VIEW;

Dependencies

[top of page]

SYS.KU$_PIOT_PART_VIEW references the following:

SchemaSYS
PL/SQL PackageDBMS_METADATA - show dependent code
PL/SQL PackageDBMS_METADATA_UTIL - show dependent code
TableIND$
TableINDPART$
TYPEKU$_DEFERRED_STG_T
ViewKU$_DEFERRED_STG_VIEW
TYPEKU$_LOBFRAG_LIST_T
ViewKU$_PIOTLOBFRAG_VIEW
TYPEKU$_PIOT_PART_T
TYPEKU$_SCHEMAOBJ_T
ViewKU$_SCHEMAOBJ_VIEW
TYPEKU$_STORAGE_T
ViewKU$_STORAGE_VIEW
PL/SQL PackageSTANDARD - show dependent code
TableTS$
SYS.KU$_PIOT_PART_VIEW is referenced by following:

SchemaSYS
ViewKU$_IOT_PARTOBJ_VIEW