Monday, November 3, 2008

ORA-02063

ORA-02063
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




Tags: ,,,,

No comments: