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

NNL-00914: Forwarding desired on server queries: string

1 Answers  


ORA-19646: cannot change size of datafile string from string to string

1 Answers  


TNS-04017: Please wait. Shutdown in progress.

1 Answers  


ORA-39129: Object type string not imported. Name conflicts with the master table

1 Answers  


RMAN-08015: datafile string switched to datafile copy

1 Answers  






LSX-00242: bad Boolean "~S"

1 Answers  


ORA-39029: worker string with process name "string" prematurely terminated

1 Answers  


ORA-01288: file string is from a different database incarnation

1 Answers  


RMAN-06493: only UNTIL TIME clause is allowed when performing a restore from autobackup, found: string

1 Answers  


ORA-06034: NETDNT: connect failed, partner exited unexpectedly

1 Answers  


IMG-00852: image index free failed

1 Answers  


ORA-24065: propagation for QUEUE string and DESTINATION string already disabled

1 Answers  


Categories