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

PLS-00329: schema-level type has illegal reference to string

1 Answers  


KUP-04040: file string in string not found

1 Answers  


RMAN-08019: channel string: restoring datafile string

1 Answers  


TNS-12166: TNS:Client can not connect to HO agent.

1 Answers  


ORA-02235: this table logs changes to another table already

1 Answers  






LPX-00122: undefined ID "~S" in IDREF

1 Answers  


ORA-24072: cannot execute MIGRATE_QUEUE_TABLE procedure; must own queue table

1 Answers  


ORA-25110: NOSORT may not be used with a bitmap index

1 Answers  


ORA-24803: illegal parameter value in lob read function

1 Answers  


RMAN-08106: channel string: restoring block(s)

1 Answers  


ORA-02057: 2PC: string: bad two-phase recovery state number string from string

1 Answers  


ORA-16573: attempt to change configuration file for an enabled broker configuration

1 Answers  


Categories