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-00034: cannot string in current PL/SQL session

1 Answers  


NNO-00615: disabling DEFAULT-FORWARDERS-ONLY mode

1 Answers  


CLSS-00102: initialization failure: [string] [string] [string] [string] [string] [string]

1 Answers  


RMAN-06747: at least 1 channel of tertiary storage must be allocated to execute this command

1 Answers  


ORA-30725: JDWP-based debugging is not yet available

1 Answers  






ORA-24171: creation properties are only for internal use

1 Answers  


TNS-04081: Event groups:

1 Answers  


ORA-07485: scg_get_inst: cannot open instance number lock.

1 Answers  


SQL*Loader-00279: Only APPEND mode allowed when parallel load specified.

1 Answers  


ORA-03290: Invalid truncate command - missing CLUSTER or TABLE keyword

1 Answers  


ORA-14002: only one GLOBAL clause may be specified

1 Answers  


TNS-01114: LSNRCTL could not perform local OS authentication with the listener

1 Answers  


Categories