QSM-01022: a more optimal materialized view than string was
used to rewrite
- 1 Answers
- 2071 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: Query Rewrite always chooses the most optimal
materialized view based on certain parameters, such as
cardinality of the materialized view, number of joins etc.
The materialized view specified was found to be less optimal.
Action: To force using a materialized view, consider using a
rewrite hint.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-25157: Specified block size string is not valid
NID-00442: Database has been shutdown, open database with RESETLOGS option.
LPX-00661: Failed to load: '~s'.
ORA-25296: Queue Table string has a buffered queue string
ORA-13463: error retrieving GeoRaster data: string
ORA-12852: PARALLEL_MIN_SERVERS must be less than PROCESSES, string
RMAN-06402: Oracle instance shut down
RMAN-06108: changed datafile copy unvailable
ORA-02821: Unable to read the requested number of blocks.
RMAN-20203: translation in progress
ORA-19675: file string was modified during proxy copy
PCC-00073: Cursor is declared but never OPENed at line number in file string.
Oracle Errors 
