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
- 2857 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 |
PLS-00229: Attribute expression within SQL expression
PLS-00587: a static method cannot be invoked on an instance value
IMG-00832: fail queue is full
ORA-01543: tablespace 'string' already exists
ORA-02222: invalid PCTINCREASE storage option value
TNS-02403: Bad alias string or alias not present in tnsnames.ora
ORA-14316: table is not partitioned by List method
ORA-39306: the schema "string" mismatch: require the schema "string"
ORA-12536: TNS:operation would block
ORA-30754: column or table string stores objects of only one type
ORA-16052: DB_UNIQUE_NAME attribute is required
ORA-14152: invalid number of partitions specified in PARTITIONS clause
Oracle Errors 
