cannot add new partition to table

Hi ,

I have created table and added a few range partitions by date,however, when i try to add new partition it gives me following error,hope anyone can help me? thanks! I am running oracle 8.1.7.4 on Solaris 2.6

SQL> alter table tb_testing add partition D2001 values less than ( ' 2002-01-01 00:00:00' ) tablespace booking_data2000;
alter table tb_testing add partition D2001 values less than ( ' 2002-01-01 00:00:00' ) tablespace booking_data2000
*
ERROR at line 1:
ORA-01861: literal does not match format string
=========================================================
the following are the information related to table partition that i have created:

SQL> select table_name,high_value,high_value_length from user_tab_partitions WHERE PARTITION_NAME LIKE 'D2000';

TABLE_NAME HIGH_VALUE HIGH_VALUE_LENGTH
------------------------------ -------------------------------------------------------------------------------- -----------------
TB_TESTING TO_DATE(' 2001-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA 83

=============================================================

Something to do with the date format.
Is there a blank space prior to YYYY. Or try with default Oracle date format.

HTH

Hi sanjay,

I have tried the same alter command w/o the space but it still give the same error. BTW what do u mean by oracle default date format? could u enlighten me?

thanks

Code:

---

alter table tb_testing add partition D2001
values less than (TO_DATE(' 2002-01-01 00:00:00','SYYYY-MM-DD HH24:MI:SS'))
tablespace booking_data2000;

---

Sanjay,

Cool! it works never thought of that :)

thanks!