1 2 Previous Next 16 Replies Latest reply: Nov 8, 2013 5:29 PM by jgarry RSS

    "ORA-02149: Specified partition does not exist" During dbms_stats.gather_table_stats

    Debadatta Kar

      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

        1 2 Previous Next