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


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

ORA-32577: username must be SYS or SYSTEM

1 Answers  


LFI-00113: Unable to initialize the Standard File object string.

1 Answers  


EXP-00040: Dump file and log file must be different

1 Answers  


TNS-01202: Missing the dba group (string) specified by DBA_GROUP in SID_DESC

1 Answers  


ORA-30991: cannot use DOM to add special attribute to schema-based parent

1 Answers  






ORA-08114: can not alter a fake index

1 Answers  


ORA-23291: Only base table columns may be renamed

1 Answers  


NCR-02007: NCRF: Invalid format descriptor received

1 Answers  


ORA-06115: NETTCP: unable to create ORACLE logicals

1 Answers  


ORA-03219: Tablespace 'string' is dictionary-managed, offline or temporary

1 Answers  


ORA-23478: object group "string" is already mastered at string

1 Answers  


DRG-10561: index string is not valid for requested operation

1 Answers  






Categories