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-06570: shared pool object does not exist, cannot be pinned

1 Answers  


TNS-01090: No longer listening on: string

1 Answers  


ORA-14278: column type or size mismatch in EXCHANGE SUBPARTITION

1 Answers  


ORA-16506: out of memory

1 Answers  


ORA-00282: UPI string call not supported, use ALTER DATABASE RECOVER

1 Answers  






DRG-50914: invalid last document number string

1 Answers  


TNS-00073: * stop/abort - stop the process_name

1 Answers  


ORA-31077: invalid attribute "string" specified

1 Answers  


ORA-16194: Modifying DB_UNIQUE_NAME requires SID='*' qualifier

1 Answers  


RMAN-08057: channel string: backup cancelled because all files were skipped

1 Answers  


EXP-00078: Error exporting metadata for index string. Index creation will be skipped

1 Answers  


ORA-28540: internal result set error

1 Answers  


Categories