QSM-02139: agg(expr) requires correspondng agg(expr+expr) function
Cause: The capability in question is not supported when the materialized view uses certain aggregate functions but omits an invocation of that same aggregate function on the same argument added to the same argument.
Action: Add the indicated aggregate function to the select list.
QSM-02140
Custom Search


More Oracle errors
TNS-00287Min Connect Time (secs) : number
QSM-01011when heuristic rewrite not set, rewrite hint required
ORA-26048Scoped REF column has wrong table name.
OCI-31066Insertion of string into string creates a cycle
ORA-04016sequence string no longer exists
ORA-00107failed to connect to ORACLE listener process
ORA-38417attribute set string does not exist
RMAN-08510archived log thread=string sequence=string
TNS-01164No spawn alias sent to listener
ORA-27458A program of type PLSQL_BLOCK cannot have any arguments.
EVM-00014Failed to write to EVM listening connection
ORA-25143default storage clause is not compatible with allocation policy
ORA-06303IPA: Message send error
ORA-06321IPA: Cannot reach the remote side
ORA-19043Multiply nested XMLROOT function disallowed
TNS-12631Username retrieval failed
ORA-14766Unable to obtain a stable metadata snapshot
DRG-50701error in listener.get_cmd()
ORA-22151cannot resize non-zero variable-length array to zero elements
ORA-33315(XSDELDENTANON) You cannot delete workspace object while looping over unnamed composite workspace object.




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-02139agg(expr) requires correspondng agg(expr+expr) function