ORA-38501: sub-query not allowed in the expression
Cause: An attempt was made to use a sub-query in the expression.
Action: Do not use sub-queries in the expressions.
ORA-38502
Custom Search


More Oracle errors
ORA-31490could not attach to LogMiner session
NZE-29044Renegotiation has already been requested.
NID-00422Change of database ID failed during validation - database is intact.
ORA-31085schema "string" already registered
ORA-01590number of segment free list (string) exceeds maximum of string
NNO-00801Error: OCI_SUCCESS_WITH_INFO: string
ORA-01609log string is the current log for thread string - cannot drop members
NNF-00005Functionality not implemented
PCC-00124COMMON_NAME option is specified too late
ORA-00490PSP process terminated with error
ORA-14612Duplicate lob segment name string for lob column string in template
ORA-26011Cannot load type string into column string in table string
ORA-14661row movement must be enabled
ORA-16722unable to set LOG_ARCHIVE_DEST_STATE_n initialization parameters
ORA-13333invalid LRS measure
ORA-07618$IDTOASC failed translating a secrecy level
PGU-41054invalid version number in VERSION parameter
ORA-02821Unable to read the requested number of blocks.
NMP-00011internal SNMP program interface error
ORA-36728(XSALERR01) While performing the ALLOCATE command with AGGMAP workspace object, the error logging limit of number was exceeded.




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
ORA-38501sub-query not allowed in the expression