Home » SQL & PL/SQL » SQL & PL/SQL » Adding Partition fails (9i)
Adding Partition fails [message #447475] Mon, 15 March 2010 07:08 Go to next message
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..

Re: Adding Partition fails [message #447481 is a reply to message #447475] Mon, 15 March 2010 07:36 Go to previous messageGo to next message
Michel Cadot
Messages: 63804
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.

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

Regards
Michel
Re: Adding Partition fails [message #447483 is a reply to message #447475] Mon, 15 March 2010 07:39 Go to previous messageGo to next message
Michel Cadot
Messages: 63804
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: Adding Partition fails [message #447494 is a reply to message #447483] Mon, 15 March 2010 08:00 Go to previous messageGo to next message
koesmet
Messages: 9
Registered: March 2010
Location: munich
Junior Member
thanx..,
how is the command? like this?

ALTER TABLE t_log
split
PARTITION P899_MCDW
at(898)
into (partition p897_fft
,partition P899_MCDW)
;
Re: Adding Partition fails [message #447495 is a reply to message #447494] Mon, 15 March 2010 08:06 Go to previous messageGo to next message
Michel Cadot
Messages: 63804
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did this work when you launched it?
I think SQL*Plus is a better syntax analyzer than I am.

Regards
Michel
Re: Adding Partition fails [message #447581 is a reply to message #447495] Tue, 16 March 2010 04:17 Go to previous message
koesmet
Messages: 9
Registered: March 2010
Location: munich
Junior Member
i launched.., and it worked!! thanx for help michel..

Previous Topic: datafile for External table
Next Topic: execution time of a query
Goto Forum:
  


Current Time: Mon Sep 26 17:54:05 CDT 2016

Total time taken to generate the page: 0.10019 seconds