ORA-00166: remote/local nesting level is too deep
What triggered the Error:
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.What should we do to fix it:
Rearrange the query or co-locate the functions with the tables.
If this was not sufficient go over to:
Oracle Official Support Knowledge Center
Or maybe those geeks at: StackOverflow Board
Or maybe those geeks at: StackOverflow Board
