QSM-02091: mv references a non-repeatable or session-sensitive expression
Cause: The capability in question is not supported when the materialized view uses an expression that may not return the same value each time it is invoked against the same set of rows or that may return different values depending on session parameters.
Action: Re-phrase the query to avoid the use of such expressions.
QSM-02092
Custom Search


More Oracle errors
ORA-06517PL/SQL: Probe error - string
PGU-41036LUNAME parameter was previously specified
ORA-30337multiple JOIN KEY clauses specified for the same parent level
ORA-12205TNS:could not get failed addresses
NNL-00975Desired data type: string
ORA-31145Duplicate listener, string, found in resource configuration
ORA-06749TLI Driver: option not allowed across network
ORA-16738redo transport service for database "string" is not running
ORA-01329unable to truncate required build table
ORA-10706Print out information about global enqueue manipulation
OCI-31105User does not own lock "string"
O2F-00302Unable to allocate memory
ORA-12067empty refresh groups are not allowed
ORA-28536error in processing Heterogeneous Services initialization parameters
ORA-07880sdopnf: internal error
PGU-30306TIP generation: invalid PL/SQL parameter mode string for string
ORA-15013diskgroup "string" is already mounted
DRG-12240ORDER BY column string must be indexed as an SDATA section
RMAN-06089archived log string not found or out of sync with catalog
ORA-14163subpartition number string: INITRANS value must be less than MAXTRANS value




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-02091mv references a non-repeatable or session-sensitive expression