Oracle database error code ORA-02022 – remote statement has unoptimized view with remote object

Oracle Database Error Code ORA-2022 Description :
remote statement has unoptimized view with remote object
Error Cause:
The local view is unoptimized and contains references to objects at the remote database and the statement must be executed at the remote database.

How to Solve :
Create a similar view on the remote database and modify the violating view in the SQL statement with the new view@remote.


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