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-34487: (MXMAINT08) You cannot string values of non-unique concat dimension workspace object.

1 Answers  


ORA-13240: specified dimensionality greater than that of the query mbr

1 Answers  


LPX-00201: unknown encoding "~s"

1 Answers  


EXP-00065: Error writing lob to the dump file.

1 Answers  


ORA-19597: file string blocksize string does not match set blocksize of string

1 Answers  






QSM-02035: no filter conditions are present in the HAVING clause

1 Answers  


ORA-40107: operation requires string option to be installed

1 Answers  


KUP-03020: empty delimiter specified for record

1 Answers  


PLS-00408: duplicate column 'string' not permitted in INSERT or UPDATE

1 Answers  


ORA-01082: 'row_locking = always' requires the transaction processing option

1 Answers  


DRG-11534: invalid column string

1 Answers  


NPL-00101: uninitialized ASN.1 context

1 Answers  


Categories