Sunday, January 8, 2012


In Sql Plus 11g oracle has new feature to log error in to one of the table system.sperrorlog. First you need to have grant privillages to this table.

Then need to run the command:
set errorlogging on table system.sperrorlog;
next run
set errorlogging on;

The you can run your scripts in the SQL plus. It will log the error, User, Which script, what time it occurred.

You can check error logged or not by
 sho errorlogging command

No comments:

Post a Comment