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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-16555: The Data Guard database is not active.

1 Answers  


NNF-02001: NIS client error string: string

1 Answers  


ORA-26085: direct path operation must start its own transaction

1 Answers  


ORA-12064: invalid refresh sequence number: string

1 Answers  


ORA-29345: can not plug a tablespace into a database using a different character set

1 Answers  






PLS-00330: invalid use of type name or subtype name

1 Answers  


ORA-06914: CMX: unexepected event during start of oracle

1 Answers  


TNS-00043: The CMANAGER has active connections, do you still want to stop it (y/n)?

1 Answers  


ORA-22140: given size [string] must be in the range of 0 to [string]

1 Answers  


ORA-01574: maximum number of concurrent transactions exceeded

1 Answers  


ORA-12661: Protocol authentication to be used

1 Answers  


ORA-30085: syntax error was found in overlaps predicate

1 Answers  


Categories