[Home] [Help] [Dependency Information]
Object Name: | ALL_TAB_PARTITIONS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TABLE_OWNER | VARCHAR2 | (128) | ||
TABLE_NAME | VARCHAR2 | (128) | ||
COMPOSITE | VARCHAR2 | (3) | ||
PARTITION_NAME | VARCHAR2 | (128) | ||
SUBPARTITION_COUNT | NUMBER | |||
HIGH_VALUE | LONG | (0) | ||
HIGH_VALUE_LENGTH | NUMBER | |||
PARTITION_POSITION | NUMBER | |||
TABLESPACE_NAME | VARCHAR2 | (30) | ||
PCT_FREE | NUMBER | |||
PCT_USED | NUMBER | |||
INI_TRANS | NUMBER | |||
MAX_TRANS | NUMBER | |||
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 | (7) | ||
COMPRESSION | VARCHAR2 | (8) | ||
COMPRESS_FOR | VARCHAR2 | (30) | ||
NUM_ROWS | NUMBER | |||
BLOCKS | NUMBER | |||
EMPTY_BLOCKS | NUMBER | |||
AVG_SPACE | NUMBER | |||
CHAIN_CNT | NUMBER | |||
AVG_ROW_LEN | NUMBER | |||
SAMPLE_SIZE | NUMBER | |||
LAST_ANALYZED | DATE | |||
BUFFER_POOL | VARCHAR2 | (7) | ||
FLASH_CACHE | VARCHAR2 | (7) | ||
CELL_FLASH_CACHE | VARCHAR2 | (7) | ||
GLOBAL_STATS | VARCHAR2 | (3) | ||
USER_STATS | VARCHAR2 | (3) | ||
IS_NESTED | VARCHAR2 | (3) | ||
PARENT_TABLE_PARTITION | VARCHAR2 | (128) | ||
INTERVAL | VARCHAR2 | (3) | ||
SEGMENT_CREATED | VARCHAR2 | (4) | ||
INDEXING | VARCHAR2 | (4) | ||
INMEMORY | VARCHAR2 | (8) | ||
INMEMORY_PRIORITY | VARCHAR2 | (8) | ||
INMEMORY_DISTRIBUTE | VARCHAR2 | (15) | ||
INMEMORY_COMPRESSION | VARCHAR2 | (17) | ||
INMEMORY_DUPLICATE | VARCHAR2 | (13) |
Cut, paste (and edit) the following text to query this object:
SELECT TABLE_OWNER
, TABLE_NAME
, COMPOSITE
, PARTITION_NAME
, SUBPARTITION_COUNT
, HIGH_VALUE
, HIGH_VALUE_LENGTH
, PARTITION_POSITION
, TABLESPACE_NAME
, PCT_FREE
, PCT_USED
, INI_TRANS
, MAX_TRANS
, INITIAL_EXTENT
, NEXT_EXTENT
, MIN_EXTENT
, MAX_EXTENT
, MAX_SIZE
, PCT_INCREASE
, FREELISTS
, FREELIST_GROUPS
, LOGGING
, COMPRESSION
, COMPRESS_FOR
, NUM_ROWS
, BLOCKS
, EMPTY_BLOCKS
, AVG_SPACE
, CHAIN_CNT
, AVG_ROW_LEN
, SAMPLE_SIZE
, LAST_ANALYZED
, BUFFER_POOL
, FLASH_CACHE
, CELL_FLASH_CACHE
, GLOBAL_STATS
, USER_STATS
, IS_NESTED
, PARENT_TABLE_PARTITION
, INTERVAL
, SEGMENT_CREATED
, INDEXING
, INMEMORY
, INMEMORY_PRIORITY
, INMEMORY_DISTRIBUTE
, INMEMORY_COMPRESSION
, INMEMORY_DUPLICATE
FROM SYS.ALL_TAB_PARTITIONS;
|
|
|