GATHER_SCHEMA_STATS & ORA-03001: unimplemented feature
Today i was gathering stats on one schema (10.2.0.3 on AIX 5.3, 64 bit) and it said: [sql]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[/sql] 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) ...