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


QSM-02187: materialized view on external table



QSM-02187: materialized view on external table..

Answer / guest

Cause: The capability in question is not supported when the
materialized view references an external table.

Action: Re-phrase the query to avoid the use of the external
tables.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

DRG-50947: ABOUT clause not allowed without a theme index

1 Answers  


ORA-32011: cannot restore SPFILE to location already being used by the instance

1 Answers  


ORA-00368: checksum error in redo log block

1 Answers  


PCC-00109: Dynamic SQL and PL/SQL are Oracle extensions to ANSI SQL

1 Answers  


ORA-40002: wordsize must be string or greater

1 Answers  






O2F-00306: Unable to close the INTYPE file

1 Answers  


ORA-32612: invalid use of FOR loop

1 Answers  


NID-00105: Need to specify "LOGFILE=<logfile>" when using APPEND=YES option

1 Answers  


ORA-30500: database open triggers and server error triggers cannot have BEFORE type

1 Answers  


ORA-02429: cannot drop index used for enforcement of unique/primary key

1 Answers  


ORA-22807: cannot resolve to a scalar type or a collection type

1 Answers  


ORA-30203: Cannot open mesage file

1 Answers  






Categories