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-14054: invalid ALTER TABLE TRUNCATE PARTITION option

1 Answers  


LSX-00342: value of attribute "base" must be a complex type definition

1 Answers  


ORA-14622: Value string already exists in subpartition string

1 Answers  


ORA-16411: ONDEMAND archival requires active managed recovery operation

1 Answers  


ORA-29802: missing CONTEXT keyword

1 Answers  






ORA-00081: address range [string, string) is not readable

1 Answers  


ORA-12703: this character set conversion is not supported

1 Answers  


QSM-02009: non-inner join

1 Answers  


CLSR-00003: ORACLE_HOME environment variable not set

1 Answers  


NZE-28821: No input buffer provided.

1 Answers  


NID-00127: All online files in the database must have the same checkpoint SCN

1 Answers  


RMAN-06731: command string:string%% complete, time left number:number:number

1 Answers  


Categories