spliting partition
nodexNov 26 2008 — edited Nov 26 2008Hello,
I need to split partition giving just one date - in example below it's 200807. It has to be 'yyyymm'. The partitions should be splited like the first has a name ending with 200807 but MaxValue in partition should be 200808.
When I try to split partition like that:
ALTER TABLE TABLE_NAME split PARTITION
PART_NAME_OVERFLOW AT (add_months(to_date('200807','yyyymm'), 1))
INTO
(PARTITION PART_NAME_200807, PARTITION PART_NAME_OVERFLOW)
it gives me : ORA-14019
partition bound element must be one of: string, datetime or interval literal, number, or MAXVALUE
I think I gave datetime as a parameter - add_months(to_date('200807','yyyymm'), 1) - it'a datetime, isn't it ?
Somebody has an idea?
Thanks