ORA-00166 Remote or Local Nesting Level is too Deep

Error Code
ORA-00166

Description
Remote/local nesting level is too deep.

Cause:
Possible cause of this error is, too many remote table operations required a reverse trip back to the local site, for example to execute a local function on a remote table.

Action
To fix this error, rearrange the query or co-locate the functions with the tables.

reference

ORA-00165 Migratable Distributed Autonomous Transaction with Remote Operation is not Allowed

Error Code
ORA-00165

Description
Migratable distributed autonomous transaction with remote operation is not allowed.

Cause
Possible cause of this error is, a request was made by the application to start a migratable distributed autonomous transaction with remote operation.

Action
none

reference

ORA-00164 Distributed Autonomous Transaction Disallowed within Migratable Distributed Transaction

Error Code
ORA-00164

Description
Distributed autonomous transaction disallowed within migratable distributed transaction

Cause
Possible cause of this error is, a request was made by the application to start a distributed autonomous transaction when the application was in a migratable distributed transaction.

Action
To fix this error, roll back or commit the current distributed transaction first.

reference

ORA-00163: Internal Database Name Length String is Greater than Maximum

Error Code
ORA-00163

Description
Internal database name length string is greater than maximum (string).

Cause
Possible cause of this error is, an internal database name with a too large length field was passed in.

Action
To fix this error, report the problem to your external transaction coordinator vendor.

reference

ORA-00162 External dbid Length String is Greater than Maximum

ErrorCode
ORA-00162

Description
External dbid length string is greater than maximum (string).

Cause
Possible cause of this error is, an external database name with too large a length field was passed in.

Action
To fix this error, report the problem to your external transaction coordinator vendor.

reference