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-30738: object "string" does not exist in schema "string"

1 Answers  


ORA-19777: ASM file string cannot be proxy backed up.

1 Answers  


AMD-00126: dimension #string: analytic workspace column level relation not specified

1 Answers  


ORA-02058: no prepared transaction found with ID string

1 Answers  


ORA-04008: START WITH cannot be more than MAXVALUE

1 Answers  






QSM-01097: Materialized view with grouping sets has too long key

1 Answers  


ORA-12528: TNS:listener: all appropriate instances are blocking new connections

2 Answers  


ORA-24755: OCI_TRANS_NOMIGRATE, OCI_TRANS_JOIN options are not supported

1 Answers  


ORA-01583: unable to get block size of controlfile to be backed up

1 Answers  


RMAN-06035: wrong version of recover.bsq, expecting string, found string

2 Answers  


ORA-23468: missing string string

1 Answers  


RMAN-10005: error opening cursor

1 Answers  


Categories