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-02250: missing or invalid constraint name

1 Answers  


ORA-24169: rule condition has unrecognized variables

1 Answers  


ORA-25462: evaluation context not specified

1 Answers  


RMAN-06080: SWITCH required for datafile string

1 Answers  


ORA-19665: size string in file header does not match actual file size of string

1 Answers  






LSX-00294: field "~S" produced multiple hits

1 Answers  


ORA-31695: Inconsistent master table on restart. The following SQL statement returned string identical objects. string

1 Answers  


NNL-00247: General request processing is now enabled

1 Answers  


ORA-22339: cannot alter to not final since its attribute column is substitutable

1 Answers  


ORA-06933: CMX: error during attach

1 Answers  


ORA-03211: The segment does not exist or is not in a valid state

1 Answers  


this is the exception raised when i am working with oracle 11g java.lang.ClassNotFoundException: oracle.jdbc.Driver.Ora cleDriver.. but i set the class path for both oracle and java..

1 Answers  


Categories