Interested to Buy Any Domain ? << Click Here >> for more details...
QSM-01125: a more optimal set operator materialized view
than string was used to rewrite
- 1 Answers
- 2932 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 |
SQL*Loader-00919: Error during upi fetch: [number]
ORA-22602: pickler TDS handle [string] is not well-formed
PLS-01403: Comment delimiters /* */
ORA-02157: no options specified for ALTER USER
ORA-30737: cannot create subtable of a type which is not a subtype of the type of the supertable
ORA-26694: error while enqueueing into queue string.string
ORA-16510: messaging error using ksrwait
ORA-29875: failed in the execution of the ODCIINDEXINSERT routine
ORA-30024: Invalid specification for CREATE UNDO TABLESPACE
ORA-23608: invalid resolution column "string"
QSM-02079: mv log must have ROWID
QSM-02128: does not meet the requirements of a primary key mv
Oracle Errors 
