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

本文介绍了在手工运行Oracle job时遇到ORA-03001错误的处理过程。通过启用errorstack的跟踪,找到了问题SQL并发现与常数索引相关。删除问题索引后,成功执行了dbms_stats.gather_schema_stats。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

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

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值