QSM-01019: no suitable materialized view found to rewrite
this query



QSM-01019: no suitable materialized view found to rewrite this query..

Answer / guest

Cause: There doesn't exist any materialized view in the
dataware house that can be used to rewrite this query.

Action: Consider creating a new materialized 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-02816: Unable to kill a process

1 Answers  


ORA-36698: (XSRELTBL03) QDR dimension workspace object should be in the dimension list that dimensions the relation.

1 Answers  


ORA-19765: mount id string does not match mount id string in control file

1 Answers  


ORA-31467: no column found in the source table

1 Answers  


ORA-33000: (AGOPEN00) AGGMAP workspace object cannot be accessed because it was compiled by a more recent version of string.

1 Answers  






TNS-00278: Navigator: Failed to Open Log file

1 Answers  


ORA-01670: new datafile string needed for standby database recovery

1 Answers  


ORA-30771: Cannot add more than one referential constraint on REF column "string"

1 Answers  


TNS-01100: TNS returned error number when attempting to start the listener

1 Answers  


ORA-38457: The attribute "string" is not a valid XMLType attribute.

1 Answers  


SQL*Loader-00114: Error in OPTIONS statement

1 Answers  


RMAN-03091: Finished string at string

1 Answers  


Categories