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.