Welcome to plsql4all.blogspot.com SQL, MYSQL, ORACLE, TERADATA, MONGODB, MARIADB, GREENPLUM, DB2, POSTGRESQL.

Monday 16 May 2016

ORA-00166

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.

No comments:

Post a Comment

Please provide your feedback in the comments section above. Please don't forget to follow.