--全局唯一索引
create table test_par1
(
tdate varchar2(8) primary key
)
partition by range ( tdate )
(
partition p1 values less than ('20090201'),
partition p2 values less than ('20090301'),
partition pm values less than (MAXVALUE)
) ;
--分区普通索引
create table test_par2
(
tdate varchar2(8)
)
partition by range ( tdate )
(
partition p1 values less than ('20090201'),
partition p2 values less than ('20090301'),
partition pm values less than (MAXVALUE)
) ;
create index i_tdate2 on test_par2(tdate) local;
alter table test_par2 add constraint pk_tdate2 primary key(tdate);
--分区唯一索引
create table test_par3
(
tdate varchar2(8),
constraint pk_tdate3 primary key (tdate) using index local
)
partition by range ( tdate )
(
partition p1 values less than ('20090201'),
partition p2 values less than ('20090301'),
partition pm values less than (MAXVALUE)
) ;