Home » SQL & PL/SQL » SQL & PL/SQL » ORA-14074: partition bound must collate higher than that of the last partition
icon4.gif  ORA-14074: partition bound must collate higher than that of the last partition [message #402499] Mon, 11 May 2009 02:55 Go to next message
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.
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
icon2.gif  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 Go to previous messageGo to next message
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!

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 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Query (merged 3)
Next Topic: regular expression with owa pattern
Goto Forum:
  


Current Time: Sun Dec 04 06:39:32 CST 2016

Total time taken to generate the page: 0.17765 seconds