ORA-02040: remote database string does not support two-phase
commit



ORA-02040: remote database string does not support two-phase commit..

Answer / guest

Cause: the database was potentially updated but does not
support prepare to commit (as determined by its logon
transaction traits). The transaction was rolled back.

Action: Do not attempt to update the remote database unless
it is the only database updated in one transaction.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-16740: log transport service for standby "string" incorrectly set to ALTERNATE.

1 Answers  


NNO-00062: cannot load domain data from configuration database

1 Answers  


ORA-02052: remote transaction failure at string

1 Answers  


NZE-28789: name type not found

1 Answers  


RMAN-05002: aborting point-in-time tablespace recovery

1 Answers  






ORA-30196: reserved for future use

1 Answers  


ORA-00348: single-process redo failure. Must abort instance

1 Answers  


ORA-06779: TLI Driver: error reading ccode

1 Answers  


ORA-14646: Specified alter table operation involving compression cannot be performed in the presence of usable bitmap indexes

1 Answers  


PCB-00302: This statement is not supported by ANSI

1 Answers  


ORA-23411: materialized view "string"."string" is not in refresh group "string"."string"

1 Answers  


RMAN-06414: target database COMPATIBLE option does not support proxy copy

1 Answers  


Categories