Error while adding new partiotion to a range partitioned table

key columns from user_part_key_columns:

44	SUMMARY	TABLE      	SERVICE_DATE	2
43	SUMMARY	TABLE      	SERVCLASS_CODE	1

existing partitions:

name: test 
less: 'PHONE', TO_DATE(' 2004-09-30 00:00:00', 'SYYYY-MM-DD
HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')

so the problem is i cannot add new partition:

name: test2
less: 'DIALUP', TO_DATE(' 2004-10-30 00:00:00', 'SYYYY-MM-DD
HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')

it seems i cannot add new partition even when my first key < that the previous. Just for example D<P.. so that's it.. am i right or ...? Received on Tue Aug 31 2004 - 04:26:28 CDT