DM数据库分区表有这么一个限制:局部唯一索引必须包含全部分区列.
SQL> create table range_part_tab (id number,deal_date date,area_code number,nbr number,contents varchar2(4000))
2 partition by range (deal_date)
3 (
4 partition p_201801 values less than (TO_DATE(‘2018-02-01’, ‘YYYY-MM-DD’)),
5 partition p_201802 values less than (TO_DATE(‘2018-03-01’, ‘YYYY-MM-DD’)),
6 partition p_201803 values less than (TO_DATE(‘2018-04-01’, ‘YYYY-MM-DD’)),
7 partition p_201804 values less than (TO_DATE(‘2018-05-01’, ‘YYYY-MM-DD’)),
8 partition p_201805 values less than (TO_DATE(‘2018-06-01’, ‘YYYY-MM-DD’)),
9 partition p_201806 values less than (TO_DATE(‘2018-07-01’, ‘YYYY-MM-DD’)),
10 partition p_201807 values less than (TO_DATE(‘2018-08-01’, ‘YYYY-MM-DD’)),
11 partition p_201808 values less than (TO_DATE(‘2018-09-01’, ‘YYYY-MM-DD’)),
12 partition p_201809 values less than (TO_DATE(‘2018-10-01’, ‘YYYY-MM-DD’)),
13 partition p_201810 values less than (TO_DATE(‘2018-11-01’, ‘YYYY-MM-DD’)),
14 partition p_201811 values less than (TO_DATE(‘2018-12-01’, ‘YYYY-MM-DD’)),
15 partition p_201812 values less than (TO_DATE(‘2019-01-01’, ‘YYYY-MM-DD’)),
16 partition p_201901 values less than (TO_DATE(‘2019-02-01’, ‘YYYY-MM-DD’)),
17 partition p_201902 values less than (TO_DATE(‘2019-03-01’, ‘YYYY-MM-DD’)),
18 partition p_max values less than