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-06736: TLI Driver: server not running

1 Answers  


NNO-00804: Error: OCI_STILL_EXECUTE

1 Answers  


PLS-00386: type mismatch found at 'string' between FETCH cursor and INTO variables

1 Answers  


ORA-38029: object statistics are locked

1 Answers  


ORA-14514: LOCAL option not valid without subpartition name

1 Answers  






SQL*Loader-00309: No SQL string allowed as part of string field specification

1 Answers  


ORA-27011: skgfrd: cannot read from file opened for write

1 Answers  


ORA-08441: closed parenthesis missing in picture mask

1 Answers  


ORA-14500: LOCAL option not valid without partition name

1 Answers  


ORA-22281: cannot perform operation with an updated locator

1 Answers  


TNS-00501: Cannot allocate memory

1 Answers  


ORA-36962: (XSRELTBL08) string is not a valid qualified data reference for dimension workspace object.

1 Answers  


Categories