MySQL Forums
Forum List  »  Partitioning

Partitioning not working need primary key?
Posted by: newbie Shai
Date: October 20, 2012 11:12AM

Dear All,
We are trying some partitioning as below.

ALTER TABLE tblreceipt PARTITION BY RANGE (MONTH(receiptDate))
(
PARTITION p1 VALUES LESS THAN (TO_DAYS('2012-10-20')),
PARTITION p2 VALUES LESS THAN (TO_DAYS('2012-10-21')),
PARTITION p3 VALUES LESS THAN (TO_DAYS('2012-10-22'))
);

but end up with this Error Code: 1503
A PRIMARY KEY must include all columns in the table's partitioning function

Options: ReplyQuote


Subject
Views
Written By
Posted
Partitioning not working need primary key?
4582
October 20, 2012 11: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.