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

VIEW: SYS.INDCOMPARTV$

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
OBJ# NUMBER
Yes
DATAOBJ# NUMBER

BO# NUMBER
Yes
PART# NUMBER

HIBOUNDLEN NUMBER
Yes
HIBOUNDVAL LONG (0)
SUBPARTCNT NUMBER
Yes
FLAGS NUMBER
Yes
DEFTS# NUMBER

DEFPCTFREE NUMBER
Yes
DEFINITRANS NUMBER
Yes
DEFMAXTRANS NUMBER
Yes
DEFINIEXTS NUMBER

DEFEXTSIZE NUMBER

DEFMINEXTS NUMBER

DEFMAXEXTS NUMBER

DEFMAXSIZE NUMBER

DEFEXTPCT NUMBER

DEFLISTS NUMBER

DEFGROUPS NUMBER

DEFLOGGING NUMBER

DEFBUFPOOL NUMBER

ANALYZETIME DATE

SAMPLESIZE NUMBER

ROWCNT NUMBER

BLEVEL NUMBER

LEAFCNT NUMBER

DISTKEY NUMBER

LBLKKEY NUMBER

DBLKKEY NUMBER

CLUFAC NUMBER

SPARE1 NUMBER

SPARE2 NUMBER

SPARE3 NUMBER

PHYPART# NUMBER
Yes
Query Text

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


SELECT OBJ#
,      DATAOBJ#
,      BO#
,      PART#
,      HIBOUNDLEN
,      HIBOUNDVAL
,      SUBPARTCNT
,      FLAGS
,      DEFTS#
,      DEFPCTFREE
,      DEFINITRANS
,      DEFMAXTRANS
,      DEFINIEXTS
,      DEFEXTSIZE
,      DEFMINEXTS
,      DEFMAXEXTS
,      DEFMAXSIZE
,      DEFEXTPCT
,      DEFLISTS
,      DEFGROUPS
,      DEFLOGGING
,      DEFBUFPOOL
,      ANALYZETIME
,      SAMPLESIZE
,      ROWCNT
,      BLEVEL
,      LEAFCNT
,      DISTKEY
,      LBLKKEY
,      DBLKKEY
,      CLUFAC
,      SPARE1
,      SPARE2
,      SPARE3
,      PHYPART#
FROM SYS.INDCOMPARTV$;

Dependencies

[top of page]

SYS.INDCOMPARTV$ references the following:

SchemaSYS
TableINDCOMPART$
SYS.INDCOMPARTV$ is referenced by following:

SchemaSYS
ViewALL_IND_STATISTICS
ViewDBA_IND_STATISTICS
Package BodyDBMS_STATS_INTERNAL - show dependent code
ViewUSER_IND_STATISTICS
View_user_stat