QSM-02150: select lists must be identical across the UNION operator
Cause: You have specified a materialized view using the UNION operator and the respective queries on each side of the UNION operator do not have the same select list. The RELATED_NAME column shows the alias of the first different select list item. The RELATED_NUM column shows the offset from the SELECT keyword to the start of this select list item.
Action: Restructure the materialized view query such that the respective sides of the UNION operator have identical select lists.
QSM-02151
Custom Search


More Oracle errors
ORA-24331user buffer too small
ORA-13647Setting of parameter string is disallowed during task execution.
PLS-00135Pragma string expects 3rd argument to be an identifier, string or numeric literal
QSM-02037cannot evaluate constant expression at compile time
TNS-00222-------------------------------------------------------------------
ORA-12203TNS:unable to connect to destination
ORA-32004obsolete and/or deprecated parameter(s) specified
OCI-22163left hand and right hand side collections are not of same type
ORA-12649Unknown encryption or data integrity algorithm
ORA-10637The segment does not exist
ORA-16548database not enabled
ORA-13470target and source layers or bands mismatched
IMP-00057Warning: Dump file may not contain data of all partitions of this table
RMAN-20204translation not started
PCC-00044Array size mismatch in INTO/USING. Minimum is: string(number:number)
ORA-14655reference partitioning constraint not found
DRG-13601Syntax error in the order attribute
NNO-00068warning: administrative region check failed, next check in number seconds
ORA-27078unable to determine limit for open files
PCC-02357Function calls may not be used as host variable expressions




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-02150select lists must be identical across the UNION operator