DBA_TAB_PARTITIONS
DBA_TAB_PARTITIONS仕様

パーティション表のパーティション情報

PROD(TOM)>desc DBA_TAB_PARTITIONS
 名前                                                NULL?    型
 ----------------------------------------------------- -------- ------------------------------------
 TABLE_OWNER                                                    VARCHAR2(30)
 TABLE_NAME                                                     VARCHAR2(30)
 COMPOSITE                                                      VARCHAR2(3)
 PARTITION_NAME                                                 VARCHAR2(30)
 SUBPARTITION_COUNT                                             NUMBER
 HIGH_VALUE                                                     LONG
 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
 PCT_INCREASE                                                   NUMBER
 FREELISTS                                                      NUMBER
 FREELIST_GROUPS                                                NUMBER
 LOGGING                                                        VARCHAR2(7)
 COMPRESSION                                                    VARCHAR2(8)
 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)
 GLOBAL_STATS                                                   VARCHAR2(3)
 USER_STATS                                                     VARCHAR2(3)

PROD(TOM)>
パーティションの基本情報
PROD(TOM)>col high_value format a70
PROD(TOM)>col table_name format a30
PROD(TOM)>col partition_name format a30
PROD(TOM)>select table_name,partition_name,high_value from user_tab_partitions;
 
TABLE_NAME                     PARTITION_NAME                 HIGH_VALUE
------------------------------ ------------------------------ ----------------------------------------------------------------------
TAB_LIST_PART                  TAB_LIST_P3                    'RAC', 'DG'
TAB_HASH_PART                  TAB_HASH_P5
TAB_RANGE_PART                 TAB_RANGE_PART01               TO_DATE(' 2009-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDA
                                                              R=GREGORIA
 
TAB_RANGE_PART                 TAB_RANGE_PART02               TO_DATE(' 2009-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDA
                                                              R=GREGORIA
 
TAB_RANGE_PART                 TAB_RANGE_PART03               TO_DATE(' 2009-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDA
                                                              R=GREGORIA
...
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License