Re: Partitioning without # of partitions
Sounds like you want a new partition automatically created every time you insert a new key?
(so adding a new state_id would create a new partition for values with that state id..)
Currently, I don't think it's possible to happen automatically. It would be straight forward, however, to have a values < MAXVALUE partition for catching new entries, and then reorganizing the MAXVALUE partition on a regular basis to handle new state_id's. You'd probably want a list or range partition in that case.
Subject
Views
Written By
Posted
3373
August 12, 2008 06:32AM
Re: Partitioning without # of partitions
2444
August 12, 2008 10:12PM
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.