Partition管理问题集锦

Partition管理问题集锦

 

 

ORA-14086: a partitioned index may not berebuilt as a whole(rebuild index)

ORA-14074: partition boundmust collate higher than that of the last partition(add partition)

 

 

ORA-14086: a partitioned index may not berebuilt as a whole(rebuild index)

 

SQL> alter index DOUDOU_GL_IDX rebuild;

alter index DOUDOU_GL_IDX rebuild

           *

ERROR at line 1:

ORA-14086: a partitionedindex may not be rebuilt as a whole

 

SQL> select index_name, partition_name,status from user_ind_partitions where

 2  index_name like'DOUDOU_GL_IDX';

 

INDEX_NAME                     PARTITION_NAME                 STATUS

------------------------------------------------------------ --------

DOUDOU_GL_IDX                  DOUDOU_13                      UNUSABLE

DOUDOU_GL_IDX                  DOUDOU_14                      UNUSABLE

DOUDOU_GL_IDX                  DOUDOU_FE                      UNUSABLE

 

SQL> alter indexDOUDOU_GL_IDX rebuild partition DOUDOU_13;

 

Index altered.

SQL> alter index DOUDOU_GL_IDX rebuildpartition DOUDOU_14;

 

Index altered.

 

SQL> alter index DOUDOU_GL_IDX rebuildpartition DOUDOU_FE;

 

Index altered.

SQL> select index_name, partition_name,status from user_ind_partitions where  index_name like 'DOUDOU_GL_IDX';

 

INDEX_NAME                     PARTITION_NAME                 STATUS

------------------------------------------------------------ --------

DOUDOU_GL_IDX                  DOUDOU_13                      USABLE

DOUDOU_GL_IDX                  DOUDOU_14                      USABLE

DOUDOU_GL_IDX                  DOUDOU_FE                      USABLE

 

 

ORA-14074: partition bound must collatehigher than that of the last partition(add partition)

 

SQL> create table t01(idnumber,name varchar2(100))

  2  partition by range(id)

  3   (

  4 partition p1 values less than(100),

  5 partition p2 values less than(200),

  6 partition p3 values less than(300),

  7 partition p4 values less than(maxvalue)

  8  );

 

Table created.

 

SQL> alter table t01 add partition p5values less than(500);

alter table t01 add partition p5 valuesless than(500)

                              *

ERROR at line 1:

ORA-14074: partition bound must collatehigher than that of the last partition

 

SQL> alter table t01 split partitionp4 at (500)

 2   into ( partition p5, partitionp4) update indexes;

 

Table altered.

 

SQL> select TABLE_NAME,PARTITION_NAMEfrom user_tab_partitions where table_name='T01';

 

TABLE_NAME                     PARTITION_NAME

------------------------------------------------------------

T01                            P1

T01                            P2

T01                            P3

T01                            P5

T01                            P4

 

 

 

未完待续…