Oracle DB Error ORA-02023 START WITH or CONNECT BY predicate cannot be evaluated by remote data base

The following is the cause of this error:

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.

Action you can take to resolve this issue: Remove the disallowed term, directly connect, or log on to the remote database.

Tags: Database, Microsoft, SQL, Oracle, Software, DBMS

Related