MySQL Forums
Forum List  »  Partitioning

Help in Paritioning the Table
Posted by: Amar Sheth
Date: May 07, 2012 05:02AM

I have Two existing Tables in my Database
1] Lecture
2] LectureContent
Both tables to related to each other Lecturecontent is Txn table to Lecture

Desgin of these tables

Lecture
---------------------------------------------------
LectureId Int PrimaryKey Auto Incr
ClassroomId Int
Date DATETIME
ActualStartTime Time
ActualEndTime Time
.........
Unqiue Key ON
(LectureId, ClassroomId, Date, ActualStartTime, ActualEndTime)


LectureContent
-----------------------------------------
LectureConentId Int PrimaryKey Auto Incr
LectureId Int
ChapterId Int
.........

Now i am trying the to create Partition on this two tables

LTER TABLE Lecture PARTITION BY RANGE(LectureId)(
PARTITION p0 VALUES LESS THAN(25000),
PARTITION p1 VALUES LESS THAN(50000),
PARTITION p2 VALUES LESS THAN(75000),
PARTITION p3 VALUES LESS THAN(100000),
PARTITION p4 VALUES LESS THAN(125000),
PARTITION p5 VALUES LESS THAN(150000),
PARTITION p6 VALUES LESS THAN(175000),
PARTITION p7 VALUES LESS THAN(200000),
PARTITION p8 VALUES LESS THAN(225000));

ALTER TABLE LectureContent PARTITION BY RANGE(LectureId)(
PARTITION p0 VALUES LESS THAN(25000),
PARTITION p1 VALUES LESS THAN(50000),
PARTITION p2 VALUES LESS THAN(75000),
PARTITION p3 VALUES LESS THAN(100000),
PARTITION p4 VALUES LESS THAN(125000),
PARTITION p5 VALUES LESS THAN(150000),
PARTITION p6 VALUES LESS THAN(175000),
PARTITION p7 VALUES LESS THAN(200000),
PARTITION p8 VALUES LESS THAN(225000),
PARTITION p9 VALUES LESS THAN(250000));

But in both case i am getting the errors
Please help?

Options: ReplyQuote


Subject
Views
Written By
Posted
Help in Paritioning the Table
2413
May 07, 2012 05:02AM
1700
May 08, 2012 09:29AM


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.