Can't add partition : ORA-14074: partition bound must collate higher than that of the
Hi all !
I have a problem adding a new partition in a range partitioned table.
The table was builded like this :
create table test
c1 char(10) not null,
c2 char(6) not null,
partition by range (c2)
(partition 199901 values less than (199902),
partition 199902 values less than (199903),
partition 200212 values less than (200301));
There are 3 bitmap indexes and 1 unique index, and there're all partitioned local.
When I tried to execute :
alter table test add partition P200301 values less than ('200302')
I received the ORA-14074 error (partition bound must collate higher than that of the last partition).
And don't understand why ?
Can anyone help me please ?
Thanks a lot in advance ...
Look at the dba_tab_partitions.high_value to find out the value for the last partition.
Use something like:
I am guessing you already have a partition that encompasses 200302.
SELECT partition_name, high_value
WHERE table_name = 'YOUR_TABLE'
AND table_owner = 'YOUR_OWNER'
ORDER BY partition_position
Unfortunatly no, the high_value for the last partition (last partition_position) is '200301'.
Hmm, do you have a maxvalue partition?
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
No, there is no maxvalue partition ...
Sounds like maybe you need to file a TAR with Oracle. Maybe your data dictionary got screwed up somehow...
Click Here to Expand Forum to Full Width