QSM-01112: WHERE clause of mv, string, is more restrictive than query
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.
QSM-01113
Custom Search


More Oracle errors
ORA-07264spwat: semop error, unable to decrement semaphore.
ORA-27027sbtremove2 returned error
PCC-02016include file pathname is too long
ORA-13068wrong table or column name in SDO_TOPO_GEOMETRY constructor
ORA-01328only one build operation may occur at one time
ORA-02442Cannot drop nonexistent unique key
RMAN-06606RMAN configuration parameters are successfully reset to default value
ORA-36924(XSVPMVTOPART05) workspace object is not in a COMPOSITE.
DRG-11122unsupported section group
ORA-27451string cannot be NULL
ORA-32101cannot create OCI Environment
ORA-02150invalid new tablespace name
ORA-31418source schema string does not exist
ORA-15078ASM diskgroup was forcibly dismounted
ORA-23537function or procedure string is not allowed to be invoked from this site.
ORA-08437invalid picture type in picture mask
SQL*Loader-02050Multibyte character error.
PGU-00386could not open toolkit resource file, string
TNS-12550TNS:syntax error
ORA-23358invalid remote user




TOP 20 Oracle errors
ORA-12504TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
RMAN-20079full resync from primary database is not done
ORA-14411The DDL cannot be run concurrently with other DDLs
ORA-14760ADD PARTITION is not permitted on Interval partitioned objects
ORA-10877error signaled in parallel recovery slave string
ORA-32701Hang detected
ORA-00838Specified value of MEMORY_TARGET is too small, needs to be at least stringM
ORA-16665timeout waiting for the result from a database
ORA-16957SQL Analyze time limit interrupt
ORA-16664unable to receive the result from a database
RMAN-08132WARNING: cannot update recovery area reclaimable file list
ORA-00000normal, successful completion
ORA-16766Redo Apply is stopped
ORA-00837Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
RMAN-08137WARNING: archived log not deleted as it is still needed
DIA-48122error with opening the ADR block file [string] [string]
ORA-47988password should contain at least one numeric and one alphabetic character
IMP-00057Warning: Dump file may not contain data of all partitions of this table
ORA-00001unique constraint (string.string) violated
ORA-55508Invalid input to Flashback Transaction Backout




Your own TOP 20 Oracle errors
QSM-01112WHERE clause of mv, string, is more restrictive than query