ORA-03001: Unimplemented Feature when Running DBMS_STATS.GATHER_INDEX_STATS

Today i was gathering stats on one schema (10.2.0.3 on AIX 5.3, 64 bit) and it said:

1 2 3 4 5 6 7

ERROR at line 1: ORA-03001: unimplemented feature ORA-06512: at "SYS.DBMS_STATS", line 13336 ORA-06512: at "SYS.DBMS_STATS", line 13682 ORA-06512: at "SYS.DBMS_STATS", line 13760 ORA-06512: at "SYS.DBMS_STATS", line 13719 ORA-06512: at line 1

Little bit of searching on Metalink revealed that i had hit Bug no 6011068 which points to the base Bug 576661 which is related to function based indexes. There were 2 function based indexes in the schema. Before talking about the workaround let us re-produce the test case. Here i am doing it on my laptop (10.2.0.1 on Windows XP 32 bit)

….

http://amardeepsidhu.com/blog/2009/07/08/gather_schema_stats-ora-03001-unimplemented-feature/

Applies to:

Oracle Server Enterprise Edition – Version: 10.2.0.1 to 10.2.0.4
Oracle Server – Personal Edition – Version: 10.2.0.1 to 10.2.0.4
Oracle Server – Standard Edition – Version: 10.2.0.1 to 10.2.0.4
This problem can occur on any platform.

Symptoms

When running dbms_stats.gather_schema_stats or dbms_stats.gather_index_stats to collect the statistics the following error occurs:

ERROR at line 1:
ORA-03001: unimplemented feature
ORA-06512: at “SYS.DBMS_STATS”, line 10640
ORA-06512: at “SYS.DBMS_STATS”, line 10664
ORA-06512: at line 1

Cause

This issue is caused by the unpublished Bug 6011068 Abstract: ORA-3001 DBMS_STATS.GATHER_TABLE_STATS which points to the base Bug 5767661 Abstract: Wrong results with function based index.

…

 

https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=559389.1

 

Enjoy..

---