-
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
=============================================================
ngwh,
Singapore.
-
Something to do with the date format.
Is there a blank space prior to YYYY. Or try with default Oracle date format.
HTH
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
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 G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
Sanjay,
Cool! it works never thought of that
thanks!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|