Oracle Database Error Code ORA-23402 Description :
refresh was aborted because of conflicts caused by deferred txns
Error Cause:
There are outstanding conflicts logged in the DefError table at the materialized views master.
How to Solve :
Resolve the conflicts in the master DefError table and refresh again after the table is empty. Alternatively, refresh with refresh_after_errors set to TRUE, which will proceed with the refresh even if there are conflicts in the masters DefError table. Proceeding despite conflicts can result with an updatable materialized views changes appearing to be temporarily lost (until a refresh succeeds after the conflicts are resolved).
Search Oracle Error Codes and Descriptions:
Be The First To Comment
Similar Errors
Please Leave Your Comments Below