eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: SYS.ALL_IND_SUBPARTITIONS

Object Details

Object Name:	ALL_IND_SUBPARTITIONS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
INDEX_OWNER	VARCHAR2	(128)	Yes
INDEX_NAME	VARCHAR2	(128)	Yes
PARTITION_NAME	VARCHAR2	(128)
SUBPARTITION_NAME	VARCHAR2	(128)
HIGH_VALUE	LONG	(0)
HIGH_VALUE_LENGTH	NUMBER		Yes
SUBPARTITION_POSITION	NUMBER
STATUS	VARCHAR2	(8)
TABLESPACE_NAME	VARCHAR2	(30)	Yes
PCT_FREE	NUMBER		Yes
INI_TRANS	NUMBER		Yes
MAX_TRANS	NUMBER		Yes
INITIAL_EXTENT	NUMBER
NEXT_EXTENT	NUMBER
MIN_EXTENT	NUMBER
MAX_EXTENT	NUMBER
MAX_SIZE	NUMBER
PCT_INCREASE	NUMBER
FREELISTS	NUMBER
FREELIST_GROUPS	NUMBER
LOGGING	VARCHAR2	(3)
COMPRESSION	VARCHAR2	(13)
BLEVEL	NUMBER
LEAF_BLOCKS	NUMBER
DISTINCT_KEYS	NUMBER
AVG_LEAF_BLOCKS_PER_KEY	NUMBER
AVG_DATA_BLOCKS_PER_KEY	NUMBER
CLUSTERING_FACTOR	NUMBER
NUM_ROWS	NUMBER
SAMPLE_SIZE	NUMBER
LAST_ANALYZED	DATE
BUFFER_POOL	VARCHAR2	(7)
FLASH_CACHE	VARCHAR2	(7)
CELL_FLASH_CACHE	VARCHAR2	(7)
USER_STATS	VARCHAR2	(3)
GLOBAL_STATS	VARCHAR2	(3)
INTERVAL	VARCHAR2	(3)
SEGMENT_CREATED	VARCHAR2	(3)

Query Text

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


SELECT INDEX_OWNER
,      INDEX_NAME
,      PARTITION_NAME
,      SUBPARTITION_NAME
,      HIGH_VALUE
,      HIGH_VALUE_LENGTH
,      SUBPARTITION_POSITION
,      STATUS
,      TABLESPACE_NAME
,      PCT_FREE
,      INI_TRANS
,      MAX_TRANS
,      INITIAL_EXTENT
,      NEXT_EXTENT
,      MIN_EXTENT
,      MAX_EXTENT
,      MAX_SIZE
,      PCT_INCREASE
,      FREELISTS
,      FREELIST_GROUPS
,      LOGGING
,      COMPRESSION
,      BLEVEL
,      LEAF_BLOCKS
,      DISTINCT_KEYS
,      AVG_LEAF_BLOCKS_PER_KEY
,      AVG_DATA_BLOCKS_PER_KEY
,      CLUSTERING_FACTOR
,      NUM_ROWS
,      SAMPLE_SIZE
,      LAST_ANALYZED
,      BUFFER_POOL
,      FLASH_CACHE
,      CELL_FLASH_CACHE
,      USER_STATS
,      GLOBAL_STATS
,      INTERVAL
,      SEGMENT_CREATED
FROM SYS.ALL_IND_SUBPARTITIONS;

Dependencies

[top of page]

SYS.ALL_IND_SUBPARTITIONS references the following:

SYS: DEFERRED_STG$; IND$; INDCOMPART$; INDSUBPART$; OBJ$; OBJAUTH$; SEG$; TAB$; TS$; USER$

SYS.ALL_IND_SUBPARTITIONS is referenced by following:

PUBLIC: ALL_IND_SUBPARTITIONS
SYS: DBMS_COMPARISON - show dependent code; DBMS_ISYNCREF - show dependent code; PRVT_COMPRESSION - show dependent code