列出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博客 ” ，链接：https://blog.itpub.net/28974745/viewspace-2138018/ ，如需转载，请注明出处，否则将追究法律责任。
