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-08111: a partitioned index may not be coalesced as a whole

1 Answers  


PCC-00137: Invalid use of SQL cursor host variable

1 Answers  


ORA-31670: Username argument must be specified and non-null.

1 Answers  


ORA-23305: internal deferred RPC error: string

1 Answers  


ORA-01948: identifier's name length (string) exceeds maximum (string)

1 Answers  






PLS-00703: multiple instances of named argument in list

1 Answers  


ORA-01559: MAXEXTENTS for rollback segment must be greater than 1

1 Answers  


PCC-02428: Buffer type is incompatible with LOB type

1 Answers  


ORA-31421: change table does not exist

1 Answers  


ORA-26520: internal memory failure

1 Answers  


PCC-00144: UNSAFE_NULL=YES must be used with DBMS=V7 and MODE=ORACLE

1 Answers  


ORA-14521: Default tablespace string block size [string] for string string does not match existing string block size [string]

1 Answers  


Categories