QSM-02008: non-join filter condition in WHERE or HAVING clause
Cause: The capability in question is not supported when the materialized view has a selection condition (an expression not representing a join) in the WHERE or HAVING clauses.
Action: Remove the selection filter expression.
QSM-02009
Custom Search


More Oracle errors
O2F-00336Error reported by subsystem:
NZE-28755object retrieval failure
ORA-26096transfer size too small for row data (number bytes required)
DRG-11861CSO-server Replies
ORA-08116can not acquire dml enough lock(S mode) for online index build
ORA-02217duplicate storage option specification
ORA-23622Operation string.string.string is in progress.
ORA-06570shared pool object does not exist, cannot be pinned/purged
ORA-41693invalid attribute or data type for an aggregate operator: string
ORA-19601output file is string string (string)
DIA-48259AMS Relation not Created Correctly
DIA-48507Predicate Not Allowed during Import
ORA-36983(XSRELGID20) The groupingid relation workspace object repeats.
NID-00333Cannot read the header of the following datafiles:
ORA-24804Lob read/write functions called while another OCI LOB read/write streaming is in progress
ORA-30565Only one INVALIDATE or UPDATE GLOBAL INDEXES clause may be specified
SQL*Loader-00823TREAT AS clause for object tables not supported for external tables
ORA-31451invalid value string for capture_values, expecting: OLD, NEW, or BOTH
ORA-02760Client close of file failed.
ORA-25133duplicate SINGLE TABLE option specified




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-02008non-join filter condition in WHERE or HAVING clause