ORA-23402: refresh was aborted because of conflicts caused
by deferred txns
- 1 Answers
- 4473 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-06727: could not locate datafilecopy string
ORA-01484: arrays can only be bound to PL/SQL statements
PCB-00556: Unrecoverable error. Fix previous errors and re-precompile
NCR-02005: NCRF: Invalid session mode
IMG-00584: output format does not support the specified compressionQuality
ORA-06111: NETTCP: disconnect failure
ORA-38498: invalid stored attribute for the index object : string
ORA-12154: TNS:could not resolve the connect identifier specified
RMAN-03018: asynchronous RPCs are working correctly
ORA-06142: NETTCP: error getting user information
ORA-22990: LOB locators cannot span transactions
LPX-00318: duplicate xsl:decimal-format "~S"
Oracle Errors 
