oracle绑定主键,请教Oracle如何给分区表添加主键

本帖最后由 zhenghaishu 于 2014-9-24 21:58 编辑

1 创建季度分区表

create table t(mydate varchar2(20), amount number) partition by range(mydate)

(

partition p20140101 values less than ('20140101') tablespace QUR_DT01,

partition p20140401 values less than ('20140401') tablespace QUR_DT02,

partition p20140701 values less than ('20140701') tablespace QUR_DT03,

partition p20141001 values less than ('20141001') tablespace QUR_DT04

);

验证：

SQL> SELECT tablespace_name,partition_name FROM dba_tab_partitions where table_name='T';

TABLESPACE_NAME                PARTITION_NAME

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

QUR_DT01                       P20140101

QUR_DT02                       P20140401

QUR_DT03                       P20140701

QUR_DT04