Creating Oracle partitioned table
Posted on 2012-04-02
I need to create a partition table that will have a Hash partition on batch_id .. Have a question..
Here is the table creation command that I plan to use:
CREATE TABLE mytab1
(BATCH_ID NUMBER DEFAULT -1,
ID number NUMBER(*,0),
PARTITION BY HASH(BATCH_ID)
STORE IN (MyTablespaceName1);
Is this a correct command to create the partitioned table on BATCH_ID? The table gets created as above.
Does it create multiple partitions for separate group of BATCH_ID values when they are inserted into the table?