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

PCC-02400: This host variable must be declared as a pointer type

1 Answers  


DRG-11713: multiple Preferred Terms per synonym ring

1 Answers  


DRG-51201: failed to perform DDL operation: database object string

1 Answers  


ORA-14030: non-existent partitioning column in CREATE TABLE statement

1 Answers  


ORA-23453: requested operation is not supported on top flavor

1 Answers  


ORA-26698: %s did not have a string rule set

1 Answers  


ORA-01095: DML statement processed zero rows

1 Answers  


ORA-32737: Hang analysis aborted due to failed memory allocation

1 Answers  


RMAN-06423: requested limit of number exceeds vendor limit of number

1 Answers  


ORA-03281: invalid ALLOCATE EXTENT option

1 Answers  


ORA-01266: Unable to create unique file name

1 Answers  


ORA-24010: QUEUE string does not exist

1 Answers  


Categories