Check an online article to display the list of events from 10000 to 10999,
I want to see if there is another one, so I will slightly modify it, from 0 to 20000, and export it to the oracle.txt file.
Set linesize 120
Set feedback off
Set serveroutput on
Spool "D: \ oracl.txt"
Declare
Err_msg varchar2 (120 );
Begin
Dbms_output.enable (1000000 );
For err_num in 0 .. 20000 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;
/
Spool off
-----------------------
Eg:
ORA-0000: Normal, successful completion
ORA-00001: violation of unique constraints (.)
ORA-00017: Request session to set trace events
ORA-00018: exceeds the maximum number of sessions
ORA-00019: Maximum number of session licenses exceeded
ORA-00020: exceeds the maximum number of processes ()
ORA-00021: Session is connected to some other processes; session cannot be switched
ORA-00022: Invalid session ID; Access Denied
ORA-00023: Session reference process dedicated memory; unable to detach session
ORA-00024: logon from multiple processes is not allowed in single process mode
...........
.........