Search This Blog


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

No comments: