SQL> createtable t1(id number)
2 partition by range(id)
3 (
4 patition q1 values less than(5),
5 patition q2 values less than(10),
6 patition q3 values less than(maxvalue)
7 );
patition q1 valuesless than(5),
*
第 4 行出现错误:
ORA-14004: 缺失 PARTITION 关键字
SQL> ed
已写入 file afiedt.buf
1 createtable t1(id number)
2 partition by range(id)
3 (
4 partition q1 values less than(5),