QSM-01125: a more optimal set operator materialized view
than string was used to rewrite
- 1 Answers
- 2448 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: Query Rewrite always chooses the most optimal set
operator materialized view based on parameters, such as
cardinality of the set operator materialized view, number of
branches that the set operator materialized view can rewrite
etc. The set operator materialized view specified was found
to be less optimal.
Action: To force using a set operator materialized view,
consider using a rewrite hint.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-00069: cannot acquire lock -- table locks disabled for string
RMAN-06114: changed controlfile copy available
ORA-16590: no primary established in Data Guard configuration
ORA-16591: unknown field "string" in document
DRG-11706: invalid relation string
ORA-29966: The only binding of an operator cannot be dropped
ORA-30191: missing argument list
ORA-04027: self-deadlock during automatic validation for object string.string
ORA-02223: invalid OPTIMAL storage option value
IMP-00066: Missing NLS_CHARACTERSET in props$
ORA-16592: missing field "string" in document
PROC-00030: Oracle Cluster Registry IDs do not match
Oracle Errors 
