Showing posts with label ORA-02022. Show all posts
Showing posts with label ORA-02022. Show all posts

Saturday, 21 January 2012

ORA-02022: remote statement has unoptimized view with remote object

ORA-02022: remote statement has unoptimized view with remote object

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.

Action: Create a similar view on the remote database and modify the violating view in the SQL statement with the new viewremote.