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 行出現(xiàn)錯(cuò)誤:ORA-00924: 缺失 BY 關(guān)鍵字不知道問題是哪里出錯(cuò)了?
Oracle問題
慕粉4349795
2017-06-12 17:21:09