将LESS改为什么呢
create table CWBB_LRB (
LRB_ID VARCHAR2(20) not null,
C_QYDM VARCHAR2(14) not null,
C_ND VARCHAR2(4) not null,
C_QYF VARCHAR2(2) not null,
C_ZYF VARCHAR2(20) not null,
)
partition by range (C_ND)
(
partition part_01 values less than(to_date('tax2005','yyyy')) tablespace tax_2005,
partition part_02 values less than(to_date('tax2006','yyyy')) tablespace tax_2006,
partition part_02 values less than(to_date('tax2007','yyyy')) tablespace tax_2007,
);
create table CWBB_LRB (
LRB_ID VARCHAR2(20) not null,
C_QYDM VARCHAR2(14) not null,
C_ND VARCHAR2(4) not null,
C_QYF VARCHAR2(2) not null,
C_ZYF VARCHAR2(20) not null,
)
partition by range (C_ND)
(
partition part_01 values less than(to_date('tax2005','yyyy')) tablespace tax_2005,
partition part_02 values less than(to_date('tax2006','yyyy')) tablespace tax_2006,
partition part_02 values less than(to_date('tax2007','yyyy')) tablespace tax_2007,
);
可以这样写吗
网上很多分区的字段都是INT或MUBER型的,如果是VARCHAR2型的,可不可以