ORA-02063: preceding string string from string string

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