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
RMAN-05058Do you want to open resetlogs the database (enter YES or NO)?
DRG-11112length of string exceeds maximum of string
ORA-13232failed to allocate memory during R-tree creation
ORA-29317datafile string does not exist
ORA-14055keyword REBUILD in ALTER INDEX REBUILD must immediately follow <index name>
ORA-10638Index status is invalid
RMAN-06935Convert script name too long
ORA-33086(XSAGINIT01) AGGMAP workspace object cannot be dimensioned by a conjoint dimension.
ORA-02254DEFAULT <expression> not allowed here
DRG-12800Attribute NESTED_TYPE must have owner name as prefix
ORA-14752Interval expression is not a constant of the correct type
DRG-12501null stoplist is not allowed
SQL*Loader-00533OCI return status: unknown, value is number
RMAN-01007at line number column number file: string
ORA-40112insufficient number of valid data rows
ORA-38461XML Tag "string" already exists for the XMLType attribute "string"
PLS-00634type with NOT INSTANTIABLE methods must be declared NOT INSTANTIABLE
RMAN-05037FOR DB_UNIQUE_NAME option cannot be used in nocatalog mode
ORA-24790cannot mix OCI_TRANS_RESUME and transaction isolation flags
TNS-00209Tracing : string




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