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

RMAN-08538: channel string: no autobackup in string days found

1 Answers  


QSM-01006: query rewrite disabled for this query block

1 Answers  


TNS-04013: CMCTL timed out waiting for Oracle Connection Manager to start

1 Answers  


ORA-39107: Master process string violated startup protocol. Master error:

1 Answers  


ORA-25186: INCLUDING clause specified for index-organized table without OVERFLOW

1 Answers  






ORA-07491: scgrcl: cannot cancel lock request.

1 Answers  


PLS-01913: : instance must of be of type 'string' or one of its subtypes

1 Answers  


ORA-01293: mounted database required for specified LogMiner options

1 Answers  


NNL-00808: Queries received, all user-defined types: number

1 Answers  


ORA-00267: name of archived log file not needed

1 Answers  


ORA-07223: slspool: fork error, unable to spawn spool process.

1 Answers  


ORA-30333: dimension does not exist

1 Answers  


Categories