Oracle Database Discussions

Hi,

I am facing an issue regarding table partitioning. I splitted a partition on a table and added a new one using below command:

ALTER TABLE infx.ncr_item_input SPLIT PARTITION MCS AT ('MID')
INTO (PARTITION MCS,PARTITION MID);

Later I faced some issue and dropped the partiton using below command:

alter table infx.ncr_item_input drop partition MID;

Now when I am trying to add the partiton again using the first command, I am getting error: ORA-14080: partition cannot be split along the specified high bound.
Although I had dropped the partiton and it is no more there in the table, it still exists somewhere in database and that I checked in the view dba_tab_partitions where I can see the values as:
Partiton_name High_value
MCS 'MID'

How do I resolve this issue? Can someone help please. Appreciate quick response.

Thanks,
Sonam