Possible Partition ?
Posted by:
Daniel tu
Date: November 20, 2008 03:45AM
Im trying to partition a table which store large amount data collected from machines. Also I dont want to keep add partition every week.
i dont think it is possible to partition a table more than 2 layer.
Is there any other way to achieve the goal.
-Year
------ Month
-------------EQID
---------------eqdata
---------------eqdata
such as
PARTITION BY RANGE(YEAR(UpdateTime))(
PARTITION P1 VALUES LESS THAN (2007)(
PARTITION BY RANGE( Month(UpdateTime) )(
SUBPARTITION BY Key( EQID) (
),
),
),
.
.
PARTITION S1 VALUES LESS THABN MAXVALUE
)
Edited 1 time(s). Last edit at 11/20/2008 03:46AM by Daniel tu.
Subject
Views
Written By
Posted
Possible Partition ?
3737
November 20, 2008 03:45AM
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.