ORA-23402: refresh was aborted because of conflicts caused
by deferred txns
- 1 Answers
- 3747 Views
- I also Faced
- E-Mail Answers
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 |
RMAN-06461: Current controlfile cannot be backed up by proxy.
ORA-16573: attempt to change configuration file for an enabled broker configuration
ORA-13122: invalid topo_geometry specified
SQL-02155: Date Time Interval only valid with Dynamic=ANSI
PLS-00363: expression 'string' cannot be used as an assignment target
QSM-02116: mupltiple master sites
ORA-04041: package specification must be created first before creating package body
ORA-06573: Function string modifies package state, cannot be used here
ORA-13768: Snaphshot ID must be between string and string.
ORA-04030: out of process memory when trying to allocate string bytes (string,string)
ORA-39030: invalid file type string
ORA-22857: cannot modify columns of object tables
Oracle Errors 
