[Home] [Help] [Dependency Information]
Object Name: | ALL_PART_INDEXES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | Yes | |
INDEX_NAME | VARCHAR2 | (128) | Yes | |
TABLE_NAME | VARCHAR2 | (128) | Yes | |
PARTITIONING_TYPE | VARCHAR2 | (9) | ||
SUBPARTITIONING_TYPE | VARCHAR2 | (9) | ||
PARTITION_COUNT | NUMBER | Yes | ||
DEF_SUBPARTITION_COUNT | NUMBER | |||
PARTITIONING_KEY_COUNT | NUMBER | Yes | ||
SUBPARTITIONING_KEY_COUNT | NUMBER | |||
LOCALITY | VARCHAR2 | (6) | ||
ALIGNMENT | VARCHAR2 | (12) | ||
DEF_TABLESPACE_NAME | VARCHAR2 | (30) | ||
DEF_PCT_FREE | NUMBER | Yes | ||
DEF_INI_TRANS | NUMBER | Yes | ||
DEF_MAX_TRANS | NUMBER | Yes | ||
DEF_INITIAL_EXTENT | VARCHAR2 | (40) | ||
DEF_NEXT_EXTENT | VARCHAR2 | (40) | ||
DEF_MIN_EXTENTS | VARCHAR2 | (40) | ||
DEF_MAX_EXTENTS | VARCHAR2 | (40) | ||
DEF_MAX_SIZE | VARCHAR2 | (40) | ||
DEF_PCT_INCREASE | VARCHAR2 | (40) | ||
DEF_FREELISTS | NUMBER | Yes | ||
DEF_FREELIST_GROUPS | NUMBER | Yes | ||
DEF_LOGGING | VARCHAR2 | (7) | ||
DEF_BUFFER_POOL | VARCHAR2 | (7) | ||
DEF_FLASH_CACHE | VARCHAR2 | (7) | ||
DEF_CELL_FLASH_CACHE | VARCHAR2 | (7) | ||
DEF_PARAMETERS | VARCHAR2 | (1000) | ||
INTERVAL | VARCHAR2 | (1000) |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, INDEX_NAME
, TABLE_NAME
, PARTITIONING_TYPE
, SUBPARTITIONING_TYPE
, PARTITION_COUNT
, DEF_SUBPARTITION_COUNT
, PARTITIONING_KEY_COUNT
, SUBPARTITIONING_KEY_COUNT
, LOCALITY
, ALIGNMENT
, DEF_TABLESPACE_NAME
, DEF_PCT_FREE
, DEF_INI_TRANS
, DEF_MAX_TRANS
, DEF_INITIAL_EXTENT
, DEF_NEXT_EXTENT
, DEF_MIN_EXTENTS
, DEF_MAX_EXTENTS
, DEF_MAX_SIZE
, DEF_PCT_INCREASE
, DEF_FREELISTS
, DEF_FREELIST_GROUPS
, DEF_LOGGING
, DEF_BUFFER_POOL
, DEF_FLASH_CACHE
, DEF_CELL_FLASH_CACHE
, DEF_PARAMETERS
, INTERVAL
FROM SYS.ALL_PART_INDEXES;
|
|
|