QSM-02154: MV is not fast refreshable even with view merging



QSM-02154: MV is not fast refreshable even with view merging..

Answer / guest

Cause: You have a materialized view with view in the FROM
clause, however it does not meet the criteria for fast
refresh after view merging.

Action: Restructure the materialized view query to remove
the offending view or the complex construct in the view.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

LFI-01508: access() failed.

1 Answers  


ORA-23458: inappropriate flavor string at string

1 Answers  


ORA-27044: unable to write the header block of file

1 Answers  


O2I-00126: You must specify an INTYPE file with SCHEMA_NAMES=FROM_INTYPE

1 Answers  


NNL-00244: Processing of modification requests is now disabled

1 Answers  






TNS-00551: underlying transport connection failed

1 Answers  


NNO-00156: warning: hint number address length number exceeds maximum of number, hint ignored

1 Answers  


PLS-01908: : RETURNING INTO buffer too small

1 Answers  


QSM-02016: clustered table in FROM list

1 Answers  


ORA-25204: invalid value, SEQUENCE_DEVIATION should be BEFORE or TOP

1 Answers  


ORA-13851: Tracing for client identifier string is already enabled

1 Answers  


ORA-19910: can not change recovery target incarnation in controlfile

1 Answers  


Categories