Oracle database error code ORA-02023 – START WITH or CONNECT BY predicate cannot be evaluated by remote data base

Oracle Database Error Code ORA-2023 Description :
START WITH or CONNECT BY predicate cannot be evaluated by remote data base
Error Cause:
The statement contains a tree query on a remote database, and the tree query's START WITH or CONNECT BY predicate contains a term that cannot be evaluated at the remote database. Such terms include calls to user functions, calls to USERENV, and references to ROWID.

How to Solve :
Remove the disallowed term, directly connect, or log on to the remote database.


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , , , ,
No Comment Yet   
«
»