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..

Advertisements


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s