OraFAQ Forum: SQL & PL/SQL » Adding Partition fails

Home » SQL & PL/SQL » SQL & PL/SQL » Adding Partition fails (9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Adding Partition fails [message #447475]

Mon, 15 March 2010 07:08

koesmet
Messages: 9
Registered: March 2010
Location: munich

Junior Member

Hi,

I want to add a partition into a ranged partioned table but I receive error:

ALTER TABLE t_log
ADD
PARTITION p897_fft
VALUES
LESS THAN (898);

ORA-14074: partition bound must collate higher than that of the last partition

i check the high value like this:
SELECT partition_name, high_value
FROM dba_tab_partitions
WHERE table_name = 'T_LOG'
AND table_owner = 'PLAT'
ORDER BY partition_position
..
..
..
P866_NNGG 867
P867_JTI 868
P869_RCC 870
P870_SUR 871
P899_MCDW 900

now, what to do? i dont want to remove Partition P899_MCDW.
How to Split?
thanx for your advises..

Report message to a moderator

Re: Adding Partition fails [message #447481 is a reply to message #447475]

Mon, 15 March 2010 07:36

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ORA-14074: partition bound must collate higher than that of the last partition
 *Cause:  Partition bound specified in ALTER TABLE ADD PARTITION
          statement did not collate higher than that of the table's
          last partition, which is illegal.
 *Action: Ensure that the partition bound of the partition to be added
          collates higher than that of the table's last partition.

As we have the definition of your partitions we can't say more.

Regards
Michel

Report message to a moderator

Re: Adding Partition fails [message #447483 is a reply to message #447475]

Mon, 15 March 2010 07:39

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Oh I see now the output of your query, I'd see it at first look if you have followed OraFAQ Forum Guide, "How to format your post?" section.

You can use ALTER TABLE SPLIT PARTITION to split it at 898.

Regards
Michel

[Updated on: Mon, 15 March 2010 07:39]

Report message to a moderator