How to divide the table into 1000 part
Hello
There is a table, into the table is a field id.
It is expected that, in this table awaken 1 billion REC.
I want to divide (through partition) this table so that:
Everi part contained one million REC.
I make this so:
PARTITION BY RANGE(id) (
PARTITION p_1 VALUES LESS THAN(1000000),
PARTITION p_2 VALUES LESS THAN(2000000),
PARTITION p_3 VALUES LESS THAN(3000000),
.................
...........
But, I have done this 1000 times by hand.
Question: This is single variant?
There is no way to do this automatically?
Thanks.
Subject
Views
Written By
Posted
How to divide the table into 1000 part
3367
February 06, 2012 01:07AM
1550
February 07, 2012 07:02PM
1575
February 08, 2012 04:12AM
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.