Showing posts with label ORA-00166: remote or local nesting level is too deep. Show all posts
Showing posts with label ORA-00166: remote or local nesting level is too deep. Show all posts

Wednesday, 4 January 2012

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

ORA-00166: remote or 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.