QSM-02099: mv references a remote table or view in the FROM list



QSM-02099: mv references a remote table or view in the FROM list..

Answer / guest

Cause: The capability in question is not supported when the
materialized view references a remote table or view in the
FROM list.

Action: Re-phrase the query to avoid references to remote
tables or views.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-08113: composite partition index may not be compressed

1 Answers  


QSM-01087: query grouping on a column that cannot be derived from materialized view, string

1 Answers  


DRG-50305: getcmd() called when one of the queue names is NULL

1 Answers  


ORA-16632: instance being added to database profile

1 Answers  


ORA-00112: value of string is null

1 Answers  






RMAN-06446: changed proxy copy unavailable

1 Answers  


TNS-02502: Authentication: unable to find initialization function

1 Answers  


ORA-19507: failed to retrieve sequential file, handle="string", parms="string"

1 Answers  


ORA-12426: invalid audit option

1 Answers  


ORA-24067: exceeded maximum number of subscribers for queue string

1 Answers  


ORA-25961: join index prevents dml cascade constraint operation

1 Answers  


NNO-00326: server statistic counter dump follows

1 Answers  


Categories