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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-10037: RPC anomaly detected on channel string, upinblt=number

1 Answers  


ORA-21708: inappropriate operation on a transient object

1 Answers  


ORA-01101: database being created currently mounted by some other instance

1 Answers  


ORA-26025: SKIP_INDEX_MAINTENANCE option requested

1 Answers  


ORA-09786: sllfop: open error, unable to open file.

1 Answers  






ORA-12209: TNS:encountered uninitialized global

1 Answers  


ORA-37104: (XSVPART04) A partitioned variable must be dimensioned by a single partition template only.

1 Answers  


DRG-11439: index name length exceeds maximum of string bytes

1 Answers  


ORA-22872: OID INDEX clause not allowed on tables with primary key based object identifiers

1 Answers  


LSX-00213: only ~1d occurrences of particle "~2S", minimum is ~3d

1 Answers  


ORA-38411: invalid datatype for the column storing expressions

1 Answers  


EXP-00087: Problem with internal hash table of schema/table names

1 Answers  


Categories