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

RMAN-06023: no backup or copy of datafile number found to restore

1 Answers  


ORA-28150: proxy not authorized to connect as client

1 Answers  


RMAN-06900: WARNING: unable to generate V$RMAN_STATUS or V$RMAN_OUTPUT row

1 Answers  


ORA-31695: Inconsistent master table on restart. The following SQL statement returned string identical objects. string

1 Answers  


ORA-15026: disk 'string' is not an ASM disk

1 Answers  






NNF-04004: Invalid string in inputfile

1 Answers  


ORA-01864: the date is out of range for the current calendar

1 Answers  


ORA-16547: cannot disable the primary database

1 Answers  


TNS-01109: Listener password encryption failed

1 Answers  


PCC-02310: formal parameter VARCHARs should be declared as pointers

1 Answers  


TNS-01304: ns secondary err code: number

1 Answers  


ORA-29503: SCHEMA keyword not valid with NAMED keyword

1 Answers  


Categories