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

ORA-32734: Error occurred when sending Oradebug command to remote DIAGs

1 Answers  


O2I-00128: Unable to write to the Java file

1 Answers  


QSM-02152: subquery or named view in FROM list even after view merging

1 Answers  


TNS-12680: Native services disabled but required

1 Answers  


ORA-32503: Mapping SGA from file failed

1 Answers  






DRG-10513: index string metadata is corrupt

1 Answers  


KUP-11002: unable to read data chunk string

1 Answers  


QSM-01002: no query rewrite when OPTIMIZER_MODE is rule based

1 Answers  


ORA-25134: keyword TABLE expected

1 Answers  


RMAN-06105: duplicate qualifier found in LIST command: string

1 Answers  


ORA-14261: partition bound may not be specified when adding this Hash partition

1 Answers  


PLS-00925: native compilation failed: Unable to create C file (string string)

1 Answers  


Categories