Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


QSM-02101: mv references a synonym in the FROM list



QSM-02101: mv references a synonym in the FROM list..

Answer / guest

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

Action: Re-phrase the query to avoid the reference to the
synonym.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-09806: Allocation of label string buffer failed.

1 Answers  


RMAN-06225: shuting down automatic instance string

1 Answers  


ORA-24032: object string exists, index could not be created for queue table string

1 Answers  


ORA-01313: LogMiner dictionary column type different from specified type

1 Answers  


ORA-02007: can't use ALLOCATE or DEALLOCATE options with REBUILD

1 Answers  






PROC-00004: The cluster registry key to be operated on does not exist.

1 Answers  


ORA-10620: Operation not allowed on this segment

1 Answers  


ORA-38418: ADT associated with the attribute set string does not exist

1 Answers  


TNS-00296: Stoppable : string

1 Answers  


RMAN-06902: AS COMPRESSED BACKUPSET option cannot be used when backing up backupsets

1 Answers  


ORA-16606: unable to find property "string"

1 Answers  


ORA-01550: cannot drop system tablespace

1 Answers  






Categories