ORA-02063: preceding stringstring from stringstring tips Oracle Error Tips by Donald Burleson(S. Karam)

The Oracle docs note this on the ora-02063 error:

Oracle MOSC documents give an account of ORA-02063 as occurring when "You want to query or update a remote table and receive the following error":

ORA-02063: preceding line from <name of a database link>

This also happens when a select is issued over a database link, and not a
distributed transaction


Solution Description
--------------------

The ORA-2063 indicates that this must be done at the remote database.


Explanation
-----------

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