Invalid data type
J1604Oct 2 2008 — edited Oct 23 2008Hi
I am trying to add partitions to my existing table.
query is as below:
alter table TABLE_NAME
ADD PARTITION BY RANGE (BEGIN_dT)
JAN__1980 VALUES LESS THAN (TO_DATE('01-FEB-1980','DD-MON-YYYY')),
feb__1980 VALUES LESS THAN (TO_DATE('01-MAR-1980','DD-MON-YYYY'));
This query returns "Invalid data type error".
Can someone tell what's wrong with it ..?
any help is appreciated.
thanks
JP