QSM-02057: ROWNUM referenced in mv
Cause: The capability in question is not supported when the materialized view references the ROWNUM function.
Action: Re-phrase the query to avoid the use of the ROWNUM function.
Custom Search

More Oracle errors
ORA-19861additional backup pieces cannot be validated in this conversation
ORA-27003cannot open file on device allocated with NOIO option
PCC-00014Undeclared SQL Identifier "string" at line number in file string
KUP-04005file operation successful
ORA-14185incorrect physical attribute specified for this index partition
OCI-04061existing state of string has been invalidated
ORA-19803Parameter DB_RECOVERY_FILE_DEST_SIZE is out of range (1 - string)
ORA-02825Request on free list was not free
ORA-06430ssaio: Seals do not match
ORA-06303IPA: Message send error
ORA-53015An internal dictionary attributes table is empty
DRG-12436document table allocation failed
TNS-00548value specified for client authentication parameter is not boolean
ORA-44302NULL network name is not permitted
ORA-14178STORE IN (DEFAULT) clause is not supported for hash partitioned global indexes
ORA-14627Invalid operation was specified on a GLOBAL partitioned index
TNS-01170Event detection broke for address: string
LPX-00751arguments "~s" are exclusive
ORA-01865not a valid era
PGA-21055error closing trace file 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-32701Hang detected
ORA-10877error signaled in parallel recovery slave string
ORA-00838Specified value of MEMORY_TARGET is too small, needs to be at least stringM
ORA-16957SQL Analyze time limit interrupt
ORA-16766Redo Apply is stopped
ORA-16664unable to receive the result from a database
RMAN-08137WARNING: archived log not deleted as it is still needed
ORA-00837Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
ORA-00000normal, successful completion
RMAN-08132WARNING: cannot update recovery area reclaimable file list
ORA-47988password should contain at least one numeric and one alphabetic character
DIA-48122error with opening the ADR block file [string] [string]
IMP-00057Warning: Dump file may not contain data of all partitions of this table
ORA-55508Invalid input to Flashback Transaction Backout
ORA-00001unique constraint (string.string) violated
ORA-16665timeout waiting for the result from a database

Your own TOP 20 Oracle errors
QSM-02057ROWNUM referenced in mv