Re: Partition and subpartition are different column
You can partition by one column and subpartition by another column, but you have to partition by range or list first and then subpartition by hash/key.
Also note that all partition and subpartition columns must be part of all unique keys (including primary key).
So I suggest you to try PARTITION BY RANGE (topic_id) SUBPARTITION BY HASH (site_id).
btw, what will the main use of partitioning be?
Subject
Views
Written By
Posted
2791
July 23, 2012 10:54AM
Re: Partition and subpartition are different column
1921
July 24, 2012 04:57AM
1780
July 28, 2012 12:42PM
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.