Oracle : Ошибка 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.

Попробовать перевести

Поискать эту ошибку на форуме