Alter table add partition error
Hi, everyone,
I am actually adding more partitions to an already existing table. My sql is
alter table dmp_tlog1_bk add partition by range (tmonth)
(
PARTITION P9_200908 VALUES less than (200909),
PARTITION P10_200909 VALUES less than (200910),
PARTITION P11_200910 VALUES less than (200911));
commit;
but i am getting the following error
Error starting at line 1 in command:
alter table dmp_tlog1_bk add partition by range (tmonth)
PARTITION P9_200908 VALUES less than (200909),
PARTITION P10_200909 VALUES less than (200910),
PARTITION P11_200910 VALUES less than (200911)
Error report:
SQL Error: ORA-00902: invalid datatype
00902. 00000 - "invalid datatype"
*Cause:
*Action:
commit succeeded.
The data type of the tmonth is number(8,0) is the table structure.
could you please help?
Thanks a many