-
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,
...
c8 number(15),
c9 number(15)
)
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:
Code:
SELECT partition_name, high_value
FROM dba_tab_partitions
WHERE table_name = 'YOUR_TABLE'
AND table_owner = 'YOUR_OWNER'
ORDER BY partition_position
I am guessing you already have a partition that encompasses 200302.
Jeff Hunter
-
Unfortunatly no, the high_value for the last partition (last partition_position) is '200301'.
-
Hmm, do you have a maxvalue partition?
Jeff Hunter
-
Sanjay G.
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...
Jeff Hunter
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
|