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
- 2927 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 |
RMAN-06129: invalid reserved channel ID: string
PCC-00016: Unable to open a cursor at line number in file string
ORA-30355: materialized view container does not exist
ORA-15066: offlining disk "string" may result in a data loss
ORA-00218: block size string of controlfile 'string' does not match DB_BLOCK_SIZE (string)
CLSR-01001: Unsupported open mode number is specified
RMAN-06908: WARNING: operation will not run in parallel on the allocated channels
NNL-00412: Number of requests: number
ORA-01051: deferred rpc buffer format invalid
ORA-38303: invalid option for PURGE TABLESPACE
NPL-00310: ASN.1 sequence has already been ended on read
PROT-00011: Failed to open the specified destination cluster registry
Oracle Errors 
