Re: partition by range on decimal type
Posted by:
Greg K
Date: November 23, 2012 12:45AM
hard to disagree with you.
one more question - how about "partition by key" ? which doesn't require to return integer, e.g.:
alter table test.bts_hour
partition by key(starttime)
partitions 20;
should it work somehow or never on decimal column?
now it gave me NULLs
partition_name part, partition_expression expr, partition_description val, partition_method meth, table_rows
+------+-----------+------+------+------------+
| part | expr | val | meth | table_rows |
+------+-----------+------+------+------------+
| p0 | starttime | NULL | KEY | 338459 |
| p1 | starttime | NULL | KEY | 320777 |
| p2 | starttime | NULL | KEY | 340764 |
...
Subject
Views
Written By
Posted
5363
November 20, 2012 07:15AM
2260
November 21, 2012 10:39AM
1756
November 22, 2012 02:26AM
1876
November 22, 2012 11:02PM
Re: partition by range on decimal type
1896
November 23, 2012 12:45AM
2051
November 23, 2012 09:03PM
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.