SQL> create table sell_new(sno,cno,cname,sname,smoney,stime)
2 partition p1 values less than(to_date('2017-01-01':'yyyy-mm-dd'))tablespace
lisu,
3 partition p1 values less than(to_date('2017-04-01':'yyyy-mm-dd'))tablespace
lisu,
4 partition p1 values less than(to_date('2017-07-01':'yyyy-mm-dd'))tablespace
lisu
5 )
6 as select * from sell;
partition p1 values less than(to_date('2017-01-01':'yyyy-mm-dd'))tablespace lisu
,
*
第 2 行出现错误:
ORA-00924: 缺失 BY 关键字
不知道问题是哪里出错了?
相关分类