QSM-02114: no GROUP BY clause, no aggregates and not >= 9.0 compatibility
Cause: The capability in question is not supported when the materialized view has no GROUP BY clause, no aggregates and compatibility mode is less than 9.0.
Action: Re-phrase the query to avoid the include a GROUP BY clause or an aggregate function. Or set compatibility mode to 9.0 or greater.
QSM-02115
Custom Search


More Oracle errors
ORA-28575unable to open RPC connection to external procedure agent
TNS-03505Failed to resolve name
ORA-29511could not resolve Java class
OCI-19208parameter string of function string must be aliased
ORA-23314database is not a materialized view site for "string"."string"
ORA-02831Segment deallocation failed - empty segment list
ORA-13769Snapshots string and string do not exist.
DRG-10825stored query does not exist: string
LSX-00169circular group reference is disallowed outside <redefine>
DIA-48491The program name is too long, exceeds the maximum length [string]
ORA-37028(XSMLTRESYNC03) Object workspace object cannot be resynced without modified object workspace object because they share a modified dimension map.
ORA-07287sksagdi: unsupported device for log archiving.
IMP-00066Missing NLS_CHARACTERSET in props$
ORA-00336log file size string blocks is less than minimum string blocks
ORA-10637The segment does not exist
ORA-24316illegal handle type
ORA-10586Test recovery had to corrupt 1 data block in order to proceed
NNO-00261cannot construct configuration checkpoint file name
PLS-00214BEGIN...END block nesting is too deep
ORA-29302database is not open clone




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-02114no GROUP BY clause, no aggregates and not >= 9.0 compatibility