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-30500database open triggers and server error triggers cannot have BEFORE type
ORA-02474Fixed hash area extents used (string) exceeds maximum allowed (string)
NZE-29232the cryptographic engine key initialization failed
TNS-00256Status of Navigator:
ORA-26054Direct Path Context prepared for a different mode than operation requested.
ORA-27302failure occurred at: string
NZE-28759failure to open file
ORA-31484source database version must be at least 9.2.0.6 or greater
ORA-36230(XSANALYZ00) object workspace object cannot be used in the ANALYZE command
ORA-25180PCTTHRESHOLD only valid for certain table organizations
ORA-29823object being analyzed is not a table
QSM-01136query has a nested table column
ORA-01375Corrupt logfile string recovered
IMG-00614I/O error during export
ORA-31076required attribute "string" not specified
RMAN-06903backup of datafile string was cancelled
ORA-22805cannot insert NULL object into object tables or nested tables
NID-00420Change of database name and ID failed during validation - database is intact.
PLS-00251RETURN, for actual function return, must be last in the parameters clause
ORA-29741IMR active for some, but not all members of cluster




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