Oracle database error code ORA-02016 – cannot use a subquery in a START WITH on a remote database

Oracle Database Error Code ORA-2016 Description :
cannot use a subquery in a START WITH on a remote database
Error Cause:
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.

How to Solve :
It is necessary to connect directly to the remote database before using a subquery in the START WITH clause.


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