While gathering stats for a table, i am getting this error. This error message seems to be misleading.
Is there any reported bug for this? If anybody faced the similar kind of situation, please share.
SQL> exec dbms_stats.gather_table_stats('NPS_NP','NPS_NP_PHYSICAL_ELEMENT_EOX', estimate_percent=>10, granularity=>'ALL', cascade=>TRUE,no_invalidate=>false);
BEGIN dbms_stats.gather_table_stats('NPS_NP','NPS_NP_PHYSICAL_ELEMENT_EOX', estimate_percent=>10, granularity=>'ALL', cascade=>TRUE,no_invalidate=>false); END;
*
ERROR at line 1:
ORA-02149: Specified partition does not exist
ORA-06512: at "SYS.DBMS_STATS", line 23829
ORA-06512: at "SYS.DBMS_STATS", line 23880
ORA-06512: at line 1
Elapsed: 05:21:40.41