| ORA-02063 | : |
preceding stringstring from stringstring |
| Cause | : |
an Oracle error was received from a remote database link. |
| Action | : |
refer to the preceding error message(s) |
More Information |
When the error is generated at the remote database it is accompanied with an
ORA-2063. In this case the parameter distributed_transactions must be increased
at the remote database.
If there is no ORA-2063 the parameter distributed_transactions must be
increased at the local database.
In a distributed environment, if a select is issued in a session without the
SET TRANSACTION READ ONLY command, the select query is considered a
distributed transaction.
If the parameter distributed_transactions is set too low, this too will result in an ORA-2042 and ORA-2063
It is important to note that ORA-02063 typically appears with ORA-02042
http://www.dba-oracle.com/t_ora_02063_preceding_stringstring_from_stringstring.htm |
|
0 comments:
Post a Comment