ORA-01220: file based sort illegal before database is open
Cause: A query issued against a fixed table or view required a temporary segment for sorting before the database was open. Only in-memory sorts are supported before the database is open.
Action: Re-phrase the query to avoid a large sort, increase the values of the SORT_AREA_SIZE and/or SORT_AREA_RETAINED_SIZE initialization parameters to enable the sort to be done in memory.
ORA-01221
Custom Search


More Oracle errors
ORA-14004missing PARTITION keyword
DGM-16991Two or more resources have the name "string"
ORA-00291numeric value required for PARALLEL option
ORA-38783Instance recovery required.
ORA-39049invalid parameter name string
PGU-35015missing field entry for transaction string string (string) call string string (string
DRG-10573index string is obsolete
QSM-02074materialized view over Heterogeneous Services link
SQL*Loader-00950Error shipping data structures across 2-task
ORA-27459A program of type EXECUTABLE must have character-only arguments.
ORA-29858error occurred in the execution of ODCIINDEXALTER routine
ORA-35016(QFCHECK00) The analytic workspace and EIF file definitions of workspace object have a mismatched type.
NNO-00612enabling request forwarding
RMAN-03031this option of set command needs to be used inside a run block
TNS-02405GMS call failed, check GMS logs.
QSM-01043join back attempted on a table to the RHS of a semi or anti join for string
NNL-00557Causes the controller to sleep for N seconds
ORA-54526multi or composite geometry must be decomposed before extraction
DIA-48315ADR unavailable
RMAN-06181multiple channels require Enterprise Edition




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-01220file based sort illegal before database is open