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-14312: Value string already exists in partition string

1 Answers  


LSX-00011: internal error: ~s

1 Answers  


ORA-29366: invalid CONSUMER_GROUP argument specified

1 Answers  


RMAN-06050: archive log thread number sequence number is already on disk as file string

1 Answers  


AMD-00111: PROCEDURE string, invalid directory: "string"

1 Answers  






PCC-00002: Invalid syntax at column number in line number of file string

1 Answers  


ORA-30196: reserved for future use

1 Answers  


TNS-01113: save_config_on_stop can either be ON or OFF

1 Answers  


ORA-07598: spwat: $SETIMR failure

1 Answers  


ORA-31516: CDC change set string already exists

1 Answers  


ORA-28666: option not allowed for an index on UROWID column(s)

1 Answers  


ORA-01029: internal two task error

1 Answers  


Categories