Skip to Main Content
Forums

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

Friend of Nov 16 2010 — edited Jan 5 2011
Hello All,

I wanted to rename an existing partition but i'm getting the above error.
I could list the partition name using "SELECT * FROM ALL_TAB_PARTITIONS WHERE TABLE_NAME IN ()"
and the partition is listed there. When i try to rename it--error!. When i try to select from the said partition
i get the same error.

Does anybody have any idea regarding this? should i run stats?

Thanks. More power.

yoy
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 2 2011
Added on Nov 16 2010
#general-database-discussions
5 comments
15,164 views