Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-02149: Specified partition does not exist

supersenDec 29 2017 — edited Feb 13 2018

Hello All

ORA-02149: Specified partition does not exist

I am getting above error while ALTER INDEX X02MAPS rebuild partition "TALP001"

But I can see partition in table

select length(PARTITION_NAME),PARTITION_NAME,status from dba_ind_partitions where INDEX_NAME='X02MAPS'

and partition_name like 'TALP001%'

LENGTH(PARTITION_NAME)
----------------------
PARTITION_NAME
--------------------------------------------------------------------------------
STATUS
--------
12
'TALP001
USABLE

This post has been answered by unknown-7404 on Dec 29 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 26 2018

Added on Dec 29 2017

#general-database-discussions

3 comments

6,150 views