增加分区遇到ORA-14074:partition bound must collate higher...
1.创建子分区表。
SQL> l
1 create table subpar_notemplate (deptno number, empname varchar(32), grade number)
2 partition by range(deptno) subpartition by hash(empname) store in(data01,data02,data03)
3 (partition p1 values less than (1000),
4 partition p2 values less than (2000),
5 partition p3 values less than (maxvalue)
6* )
SQL> /
Table created.
2.经检查,存储在了一个表空间中,是因为语法错误:
select table_name,partition_name,subpartition_name,tablespace_name from user_tab_subpartitions;
TABLE_NAME PARTITION_NAME SUBPARTITION_NAME TABLESPACE_NAME
------------------------------ ------------------------------ ------------------------------ ------------------------------
SUBPAR_NOTEMPLATE P1