手工运行oracle job时报ora-03001,ORA-03001: unimplemented feature 报错处理

ORA-03001: unimplemented feature 报错处理

客户数据库出现 ORA-03001错误。

问题重现如下：

SQL> create table drive(id int);

Table created.

SQL> insert into drive select  rownum from all_objects where rownum<=10;

10 rows created.

SQL> commit;

Commit complete.

SQL> create table inner_table as select * from all_objects where rownum<=100000;

Table created.

SQL> exec dbms_stats.gather_schema_stats(user,degree=>2);

BEGIN dbms_stats.gather_schema_stats(user,degree=>2); END;

*

ERROR at line 1:

ORA-03001: unimplemented feature

ORA-06512: at "SYS.DBMS_STATS", line 13591

ORA-06512: at "SYS.DBMS_STATS", line 13937

ORA-06512: at "SYS.DBMS_STATS", line 14015

ORA-06512: at "SYS.DBMS_STATS", line 13974

ORA-06512: at line 1

SQL> ! oerr ora 3001

03001, 00000, "unimplemented feature"

// *Cause:  This feature is not implemented.

// *Action:  None.

考虑启用errorstack的跟踪来找到出现问题的SQL语句。

SQL> alter session set events '3001 trace name errorstack level 3';

Session altered.

SQL> exec dbms_stats.gather_schema_stats(user);

BEGIN dbms_stats.gather_schema_stats(user); END;

*

ERROR at line 1:

ORA-03001: unimplemented feature

ORA-06512: at "SYS.DBMS_STATS", line 13591

ORA-06512: at "SYS.DBMS_STATS", line 13937

ORA-06512: at "SYS.DBMS_STATS", line 14015

ORA-06512: at "SYS.DBMS_STATS", line 13974

ORA-06512: at line 1

在跟踪文件里可以看到如下信息：

Wed Aug 18 15:27:48 2010

Errors in file /u01/oracle/admin/uatdb2/udump/uatdb2_ora_18481228.trc:

ORA-03001: unimplemented feature

打开跟踪文件：

Oracle Database 10g