QSM-02084: DISTINCT clause on a duplicate sensitive aggregate function
Cause: The capability in question is not supported when the materialized view uses the DISTINCT clause in this context.
Action: Re-phrase the query to avoid the use of the DISTINCT clause.
QSM-02086
Custom Search


More Oracle errors
EXP-00098Data in table has not been upgraded, table will not be exported
PLS-00442CONTINUE statement may not have the prefix STANDARD
RMAN-08085created script string
ORA-00285TIME not given as a string constant
ORA-24052cannot propagate object type payloads with LOB attributes to an 8.0 release
LSX-00310local element or attribute should be namespace qualified
ORA-13276internal error [string] in coordinate transformation
ORA-12496cannot change existing level, category, or release numbers
ORA-26086direct path does not support triggers
DIA-48193OS command to open a directory failed
TNS-01154SID detected in old format that is no longer supported
ORA-36924(XSVPMVTOPART05) workspace object is not in a COMPOSITE.
ORA-22621error transfering an object from the agent
DGM-16917Unable to shut down instance "string"
SQL*Loader-00651error skipping lob for column string, row number, table string
ORA-01202wrong incarnation of this file - wrong creation time
UDI-00005unexpected End-Of-File encountered while reading input.
ORA-27088unable to get file status
ORA-13707Either the start snapshot string or the end snapshot string is incomplete or missing key statistics.
ORA-19803Parameter DB_RECOVERY_FILE_DEST_SIZE is out of range (1 - 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-02084DISTINCT clause on a duplicate sensitive aggregate function