Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


ORA-23402: refresh was aborted because of conflicts caused
by deferred txns



ORA-23402: refresh was aborted because of conflicts caused by deferred txns..

Answer / guest

Cause: There are outstanding conflicts logged in the
DefError table at the materialized view's master.

Action: 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
master's DefError table. Proceeding despite conflicts can
result with an updatable materialized view's changes
appearing to be temporarily lost (until a refresh succeeds
after the conflicts are resolved).

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

LFI-00127: No Record Format was specified, default is variable.

1 Answers  


ORA-00363: log is not the archived version

1 Answers  


NZE-28783: invalid parameter

1 Answers  


ORA-31196: XML nodes over string in size cannot be printed

1 Answers  


ORA-22804: remote operations not permitted on object tables or user-defined type columns

1 Answers  






ORA-01680: unable to extend LOB segment by string in tablespace string

1 Answers  


TNS-01176: Error in loading the new parameter value

1 Answers  


ORA-09933: Deletion of old password file failed.

1 Answers  


ORA-24017: cannot enable enqueue on QUEUE, string is an exception queue

1 Answers  


PLS-00450: a variable of this private type cannot be declared here

1 Answers  


PLS-00400: different number of columns between cursor SELECT statement and return value

1 Answers  


DRG-11204: user filter command is too long

1 Answers  






Categories