Search This Blog

2010-08-31

Capture Oracle Warehouse Builder Mutating Error

Oracle Warehouse Builder's GUI shows limited information for mutating table error. The application does not offer any configuration which allow user to display additional error message.

Use following method to create log file, which will help to identify the root cause

alter system set events ‘4091 trace name errorstack level 3’;

After completed, remove the setting using
alter system reset events ‘4091 trace name errorstack level 3’ scope=spfile sid="*";
shutdown immediate
startup

No comments: