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 (Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi)

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

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

Fri, 17 August 2012 03:26

msol25
Messages: 211
Registered: June 2011
Location: Mumbai

Senior Member

Dear Michel/Experts,

How we can resolve below mentioned error :



ORA-14074: partition bound must collate higher than that of the last partition
ORA-06512: at "GSMCRMDW.EXCHANGE_PARTITION_WSD", line 231
ORA-06512: at "GSMCRMDW.EXCHANGE_PARTITION_WSD", line 378
ORA-06512: at line 2

Report message to a moderator

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

Fri, 17 August 2012 03:30

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

Regards
Michel

Report message to a moderator

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

Fri, 17 August 2012 08:38

msol25
Messages: 211
Registered: June 2011
Location: Mumbai

Senior Member

Thanks Michel !!!

Report message to a moderator

Previous Topic:	ORA-01031,ORA-06512 dbms_session.set_context error
Next Topic:	use defined exception

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 20 00:13:17 CDT 2013

Total time taken to generate the page: 0.16633 seconds