Partition by range (Every 500,000 records )

[arda tunccekic]

Hi,
I can "alter table" and define partitions by every 500,000 records like:

alter table mytable
partition by range (id)
(
partition p_1 values less than(500000),
partition p_2 values less than(1000000),
...
...
partition p_200 values less than(100000000)
)


Is there a syntax allowing to define partitions for "every 500000 id" until there's no disk space left?

Thanks