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 ．．．
page_revision: 6, last_edited: 1258552584|%e %b %Y, %H:%M %Z (%O ago)
