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

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