PLS-00398: wrong number of columns in UNION, INTERSECT, or MINUS expression
Cause: The SELECT clauses to the left and right of a UNION, INTERSECT, or MINUS expression do not select the same number of columns. For example, the following statement is faulty because the select lists do not contain the same number of items: CURSOR my_cur IS SELECT ename FROM emp INTERSECT SELECT ename, empno FROM emp;
Action: Change the select lists so that they contain the same number of items.
PLS-00399
Custom Search


More Oracle errors
ORA-13044the specified tile size is smaller than the tolerance
PLS-00508The expression in a RETURN statement cannot be a type
ORA-25130cannot modify primary key - primary key not defined for table
SQL*Loader-00817error dropping directory object string
IMG-01005unsupported DICOM transfer syntax
ORA-39800Database version number does not support the load of multiple subtypes.
ORA-10564tablespace string
SQL*Loader-00421error converting data
IMP-00019row rejected due to ORACLE error number
ORA-25112maximum number of BITMAP index columns is 30
OCI-31029Cannot bind to unsaved resource
ORA-02434cannot enable unique(string) - unique key not defined for table
ORA-06022NETASY: channel open failure
PCC-00047Unterminated comment/string constant beginning near line number in file string
EXP-00074rounding VOLSIZE down, new value is string
LSX-00141ID type may only be used in attributes
SQL*Loader-00560error reading file
RMAN-06051DELETE INPUT option not implemented yet
DRG-11111value of string must be between string and string
ORA-47300Role already string defined




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
PLS-00398wrong number of columns in UNION, INTERSECT, or MINUS expression