分区表 主键全局索引和分区索引区别

SQL> create table pdba (agmt_id number,corp_org char(10),agmt_mod_cd char(10),a1 number,a2 number,a3 number,a4 number, start_date date) partition by range (start_date )
(
partition p1 values less than (to_date('2010-10-1', 'yyyy-mm-dd')),
partition p2 values less than (to_date('2010-11-1', 'yyyy-mm-dd')),
partition p3 values less than (to_date('2010-12-1', 'yyyy-mm-dd')),
partition p4 values less than (maxvalue)
)
  2    3    4    5    6    7    8  ;

表已创建。

SQL> desc pdba;
 名称                                    是否为空? 类型
 ----------------------------------------- -------- ----------------------------
 AGMT_ID					    NUMBER
 CORP_ORG					    CHAR(10)
 AGMT_MOD_CD					    CHAR(10)
 A1						    NUMBER
 A2						    NUMBER
 A3						    NUMBER
 A4						    NUMBER
 START_DATE					    DATE



主键为分区索引:

alter table pdba add primary key (AGMT_ID, CORP_ORG, AGMT_MOD_CD) USING INDEX LOCAL;


SQL>