--创建间隔分区表
create table sales
(
sales_id number,
sales_dt date
)
partition by range (sales_dt)
interval (numtoyminterval(1,'MONTH'))
(
partition p1001 values less than (to_date('2010-01-01','yyyy-mm-dd')),
partition p1002 values less than (to_date('2010-02-01','yyyy-mm-dd'))
);
select * from sales partition for (to_date('2010-01-15','yyyy-mm-dd')) --这句出错
ORA-14763: 无法将 FOR VALUES 子句解析为分区编号
不知道错在哪!望高手们解答下!
10g不支持,11g才支持interval分区10必须删除这行 interval (numtoyminterval(1,'MONTH'))