[Home] [Help] [Dependency Information]
Object Name: | ALL_PART_TABLES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | ||
TABLE_NAME | VARCHAR2 | (128) | ||
PARTITIONING_TYPE | VARCHAR2 | (9) | ||
SUBPARTITIONING_TYPE | VARCHAR2 | (9) | ||
PARTITION_COUNT | NUMBER | |||
DEF_SUBPARTITION_COUNT | NUMBER | |||
PARTITIONING_KEY_COUNT | NUMBER | |||
SUBPARTITIONING_KEY_COUNT | NUMBER | |||
STATUS | VARCHAR2 | (8) | ||
DEF_TABLESPACE_NAME | VARCHAR2 | (30) | ||
DEF_PCT_FREE | NUMBER | |||
DEF_PCT_USED | NUMBER | |||
DEF_INI_TRANS | NUMBER | |||
DEF_MAX_TRANS | NUMBER | |||
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 | |||
DEF_FREELIST_GROUPS | NUMBER | |||
DEF_LOGGING | VARCHAR2 | (7) | ||
DEF_COMPRESSION | VARCHAR2 | (8) | ||
DEF_COMPRESS_FOR | VARCHAR2 | (30) | ||
DEF_BUFFER_POOL | VARCHAR2 | (7) | ||
DEF_FLASH_CACHE | VARCHAR2 | (7) | ||
DEF_CELL_FLASH_CACHE | VARCHAR2 | (7) | ||
REF_PTN_CONSTRAINT_NAME | VARCHAR2 | (128) | ||
INTERVAL | VARCHAR2 | (1000) | ||
IS_NESTED | VARCHAR2 | (3) | ||
DEF_SEGMENT_CREATION | VARCHAR2 | (4) | ||
DEF_INDEXING | VARCHAR2 | (3) | ||
DEF_INMEMORY | VARCHAR2 | (8) | ||
DEF_INMEMORY_PRIORITY | VARCHAR2 | (8) | ||
DEF_INMEMORY_DISTRIBUTE | VARCHAR2 | (15) | ||
DEF_INMEMORY_COMPRESSION | VARCHAR2 | (17) | ||
DEF_INMEMORY_DUPLICATE | VARCHAR2 | (13) |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, TABLE_NAME
, PARTITIONING_TYPE
, SUBPARTITIONING_TYPE
, PARTITION_COUNT
, DEF_SUBPARTITION_COUNT
, PARTITIONING_KEY_COUNT
, SUBPARTITIONING_KEY_COUNT
, STATUS
, DEF_TABLESPACE_NAME
, DEF_PCT_FREE
, DEF_PCT_USED
, 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_COMPRESSION
, DEF_COMPRESS_FOR
, DEF_BUFFER_POOL
, DEF_FLASH_CACHE
, DEF_CELL_FLASH_CACHE
, REF_PTN_CONSTRAINT_NAME
, INTERVAL
, IS_NESTED
, DEF_SEGMENT_CREATION
, DEF_INDEXING
, DEF_INMEMORY
, DEF_INMEMORY_PRIORITY
, DEF_INMEMORY_DISTRIBUTE
, DEF_INMEMORY_COMPRESSION
, DEF_INMEMORY_DUPLICATE
FROM SYS.ALL_PART_TABLES;
|
|
|