OraFAQ Forum: SQL & PL/SQL » ORA-14074: partition bound must collate higher than that of the last partition

Home » SQL & PL/SQL » SQL & PL/SQL » ORA-14074: partition bound must collate higher than that of the last partition

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

ORA-14074: partition bound must collate higher than that of the last partition [message #402499]

Mon, 11 May 2009 02:55

goodarzi121
Messages: 2
Registered: May 2009
Location: Iran. Tehran. DPI. Co.

Junior Member

Hi.
i want to add partition to my table, raised this error:

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

i think that raised error, because i have a partition with "MaxValue".

please help me! tank you.

Report message to a moderator

Re: ORA-14074: partition bound must collate higher than that of the last partition [message #402506 is a reply to message #402499]

Mon, 11 May 2009 03:35

Michel Cadot
Messages: 68765
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.

Quote:

i think that raised error, because i have a partition with "MaxValue".

Correct.

Regards
Michel

Report message to a moderator

Re: ORA-14074: partition bound must collate higher than that of the last partition [message #402508 is a reply to message #402506]

Mon, 11 May 2009 03:43

goodarzi121
Messages: 2
Registered: May 2009
Location: Iran. Tehran. DPI. Co.

Junior Member

tanks.

i have 13 partitions and 23398591 rows in my table, then , i have 2 solutions:

1) add partition p14:
ALTER TABLE MY_PART ADD PARTITION P14 VALUES LESS THAN(24000000) TABLESPACE TPS_01

2) or alter p13, and change MaxValue to 24000000!

but in raised ORA-14074!

Report message to a moderator

Re: ORA-14074: partition bound must collate higher than that of the last partition [message #402509 is a reply to message #402508]

Mon, 11 May 2009 03:48

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

Senior Member
Account Moderator

Quote:

i have 13 partitions and 23398591 rows in my table, then , i have 2 solutions:

In order to achieve what?
Anywhere you post what you want to do.

And remember we have NOT your DDL.

Regards
Michel

Report message to a moderator

Previous Topic:	Query (merged 3)
Next Topic:	regular expression with owa pattern

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Aug 03 22:10:53 CDT 2025