Oracle DB Error ORA-02016 cannot use a subquery in a START WITH on a remote database

The following is the cause of this error:

An attempt was made to use a subquery in a START WITH clause. Such a subquery is not currently permitted if the table in the FROM clause of the tree query is in a remote database.

Action you can take to resolve this issue: It is necessary to connect directly to the remote database before using a subquery in the START WITH clause.

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

Related