Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

OCI-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 view@remote.