改变索引的的问题！！急！！

Question

select pct_used from sys.index_stats where name='INDEXNAME';

Answer 1

SQL> desc salgrade;
 名称                                      空?      类型
 ----------------------------------------- -------- ---------------- GRADE                                              NUMBER
 LOSAL                                              NUMBER
 HISAL                                              NUMBERSQL> create index sal_index on salgrade (grade);索引已创建。
SQL> alter index sal_index maxtrans 5;索引已更改。
SQL> alter index sal_index maxtrans 255;索引已更改。SQL> alter index sal_index maxtrans 256;
alter index sal_index maxtrans 256
                               *
ERROR 位于第 1 行:
ORA-02209: 无效的 MAXTRANS 选项值

Answer 2

select max_trans from dba_indexes where index_name='xxx';

Answer 3

SQL> desc dba_indexes
 Name                            Null?    Type
 ------------------------------- -------- ----
 OWNER                           NOT NULL VARCHAR2(30)
 INDEX_NAME                      NOT NULL VARCHAR2(30)
 TABLE_OWNER                     NOT NULL VARCHAR2(30)
 TABLE_NAME                      NOT NULL VARCHAR2(30)
 TABLE_TYPE                               VARCHAR2(11)
 UNIQUENESS                               VARCHAR2(9)
 TABLESPACE_NAME                 NOT NULL VARCHAR2(30)
 INI_TRANS                       NOT NULL NUMBER
 MAX_TRANS                       NOT NULL NUMBER
 INITIAL_EXTENT                           NUMBER
 NEXT_EXTENT                              NUMBER
 MIN_EXTENTS                     NOT NULL NUMBER
 MAX_EXTENTS                     NOT NULL NUMBER
 PCT_INCREASE                    NOT NULL NUMBER
 FREELISTS                                NUMBER
 FREELIST_GROUPS                          NUMBER
 PCT_FREE                        NOT NULL NUMBER
 BLEVEL                                   NUMBER
 LEAF_BLOCKS                              NUMBER
 DISTINCT_KEYS                            NUMBER
 AVG_LEAF_BLOCKS_PER_KEY                  NUMBER
 AVG_DATA_BLOCKS_PER_KEY                  NUMBER
 CLUSTERING_FACTOR                        NUMBER
 STATUS                                   VARCHAR2(11)

Answer 4

aweihz(我怎么还没有星？？！) 的方法应该可以的。select max_trans from dba_indexes where index_name='BEFORE_PK'
 MAX_TRANS
----------
       255
1 row selected