QSM-01022: a more optimal materialized view than string was
used to rewrite
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-13408: invalid blockSize storage parameter
ORA-02050: transaction string rolled back, some remote DBs may be in-doubt
DRG-11006: invalid alter index parameter string
NNL-00517: Insert-replaces a data item under an existing name
ORA-12716: Cannot ALTER DATABASE CHARACTER SET when CLOB data exists
NNL-00213: No entry with specified index number, try "SHOW SYSTEM_QUERIES"
ORA-24094: invalid transformation, target type does not match that of the queue
PLS-00211: CASE labels or ranges must not be duplicated in different WHEN clauses
RMAN-06020: connected to auxiliary database (not started)
ORA-32606: missing NAV keyword in MODEL clause
PCB-00318: ARRAYLEN is an Oracle extension
PROT-00006: The specified import file cannot be found