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


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

SQL-02120: First and second arguments to SQLRCN both null

1 Answers  


TNS-02401: gbname string too long, allowed number characters

1 Answers  


NNC-00401: program interface initialization failed

1 Answers  


RMAN-08546: channel string: autobackup found in the recovery area

1 Answers  


ORA-02735: osnfpm: cannot create shared memory segment

1 Answers  






ORA-00151: invalid transaction ID

1 Answers  


ORA-19566: exceeded limit of string corrupt blocks for file string

1 Answers  


RMAN-06045: LEVEL option not supported for archive log or current/standby controlfile copies

1 Answers  


RMAN-06724: backup not done; all files already backed up

1 Answers  


IMP-00025: for DBA export files, FROMUSER must be specified with TOUSER option

1 Answers  


ORA-16112: log mining and apply stopping

1 Answers  


ORA-01946: DEFAULT TABLESPACE already specified

1 Answers  






Categories