ORA-00166: remote/local nesting level is too deep

Error Message

ORA-00166: remote/local nesting level is too deep

Cause

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

Rearrange the query or co-locate the functions with the tables.

You May Also Like

Leave a Reply?