Partition by range (Every 500,000 records )
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
Subject
Views
Written By
Posted
Partition by range (Every 500,000 records )
1745
August 03, 2017 02:32AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.