DBA_TAB_PARTITIONS

SQL> DESC DBA_TAB_PARTITIONS

 Name                                     Null?    Type
 ------------------------------------------------- ----------------------------
 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
 MAX_SIZE                                                NUMBER
 PCT_INCREASE                                      NUMBER
 FREELISTS                                              NUMBER
 FREELIST_GROUPS                              NUMBER
 LOGGING                                                VARCHAR2(7)
 COMPRESSION                                        VARCHAR2(8)
 COMPRESS_FOR                                      VARCHAR2(18)
 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)

No comments:

Post a Comment