Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
Description
Instead of
create or replace table t1 (x int) |
partition by range(x) ( |
partition p1 values less than (10), |
partition p2 values less than (20), |
partition p3 values less than (30), |
partition p4 values less than (40), |
partition p5 values less than (50), |
partition pn values less than maxvalue); |
it should be possible to type in shorter form:
create or replace table t1 (x int) |
partition by range(x) ( |
p1 values less than (10), |
p2 values less than (20), |
p3 values less than (30), |
p4 values less than (40), |
p5 values less than (50), |
pn values less than maxvalue); |
As above examples demonstrate, make PARTITION keyword in partition definition optional.