ORA-26536: refresh was aborted because of conflicts caused
by deferred transactions






ORA-26536: refresh was aborted because of conflicts caused by deferred transactions..

Answer / guest

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

Action: Resolve the conflicts in the master DEFERROR table
and refresh again after the table is empty. Alternatively,
refresh with REFRESH_AFTER_ERRORS, even if there are
conflicts in the master's DEFERROR table. Proceeding despite
conflicts can result in 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

ORA-12052: cannot fast refresh materialized view string.string

1 Answers  


TNS-02512: Invalid status received

1 Answers  


ORA-13138: could not determine name of object string

1 Answers  


ORA-16788: Unable to set one or more database configuration property values

1 Answers  


TNS-01109: Listener password encryption failed

1 Answers  






RMAN-08094: channel string: specifying datafile(s) for proxy restore

1 Answers  


ORA-19852: error creating services for auxiliary instance string (error string)

1 Answers  


ORA-07594: spiip: $GETJPIW failure

1 Answers  


IMG-00717: destination image format does not support process options

1 Answers  


QSM-02101: mv references a synonym in the FROM list

1 Answers  


PCC-02111: CHAR_MAP option ignored. Only CHAR_MAP=VARCHAR2 allowed for DBMS=V6

1 Answers  


DRG-50915: last document number string is not an integer

1 Answers  






Categories