QSM-01112: WHERE clause of mv, string, is more restrictive
than query
- 1 Answers
- 3982 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: The materialized view contains a selection condition
in the WHERE clause that is more restrictive than the
corresponding selection condition in the request query.
Action: Change the selection criteria in the request query
to be at least as restrictive as the selection criteria in
the materialized view, or drop and recreate the materialized
view using less restrictive selection criteria.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-09928: Unable to restore the label of server
ORA-14046: a partition may be split into exactly two new partitions
ORA-01211: Oracle7 data file is not from migration to Oracle8
ORA-39015: job is not running
RMAN-06098: the target database must be mounted when issuing a BACKUP command
PCC-02434: FOR clause not permitted in any LOB statement
RMAN-06032: at least 1 channel of TYPE DISK must be allocated to execute a COPY command
ORA-30113: error when processing file 'string'
PCB-00700: This statement can only be used with DYNAMIC=ANSI
ORA-31686: error creating worker processes
TNS-04006: Invalid password
NID-00490: LOG being redirected to STDERR due to errors.
Oracle Errors 
