Oracle错误号检索

列出ORA-01578至ORA-01580错误号说明

set serveroutput on

declare

err_msg varchar2(200);

begin

dbms_output.enable(1000000);

for err_num in 1578..1580

loop

err_msg:=sqlerrm(-err_num);

if err_msg not like '%Message '||err_num||' not found%' then

dbms_output.put_line(err_msg);

end if;

end loop;

end;

/

 

ORA-01578: ORACLE 数据块损坏 (文件号 , 块号 )

ORA-01579: 恢复过程中出现写错误

ORA-01580: 创建控制备份文件  时出错

 

对于单个错误号

set serveroutput on

exec dbms_output.put_line(sqlerrm(-04031));

 

ORA-04031: 无法分配  字节的共享内存 ("","","","")

 

在linux中可以使用oerr命令查看错误解释

oerr ora 1578

 

01578, 00000, "ORACLE data block corrupted (file # %s, block # %s)"

// *Cause:  The data block indicated was corrupted, mostly due to software

//            errors.

// *Action: Try to restore the segment containing the block indicated. This

//            may involve dropping the segment and recreating it. If there

//            is a trace file, report the errors in it to your ORACLE

//            representative.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28974745/viewspace-2138018/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28974745/viewspace-2138018/