Invalid data type [message #351697] |
Thu, 02 October 2008 09:18  |
parmarjm
Messages: 25 Registered: October 2006
|
Junior Member |
|
|
Hi
I am creating partition on a table.
query
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'));
when I run above query received below error.
ORA-00902: invalid datatype
can some one suggest me where I am doing wrong ?
any help is appreciated.
Thnks
JP
|
|
|
|
|
|
|
|
|
Re: Invalid data type [message #352508 is a reply to message #352507] |
Wed, 08 October 2008 01:59  |
 |
Michel Cadot
Messages: 68737 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Actually OP's statement is fully invalid whether the table is already partitioned or not and if he used SQL*Plus as recommended we would see it at first sight:
SQL> alter table t add partition by range (id) x values less than (10);
alter table t add partition by range (id) x values less than (10)
*
ERROR at line 1:
ORA-00902: invalid datatype
Regards
Michel
|
|
|