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
CLSR-00513Message file is not found
SQL*Loader-00309No SQL string allowed as part of string field specification
ORA-01315Log file has been added or removed during select
ORA-01881timezone region id number is invalid
PGU-41094call name string or specified version (number) of call name string does not exist
ORA-07278splon: ops$username exceeds buffer length.
ORA-60002adding (string) blocks to temporary segment in tablespace string with MAXSIZE (string)
PCC-02417Illegal type conversion between attribute and host variable
ORA-30363columns in a dimension column list must be in the same relation
ORA-04061existing state of string has been invalidated
ORA-47404NULL trust level for Factor string
PCC-02359Identifier specifying ARRAYLEN must be a 4-byte integer
NCR-03014NCRO: Bad transport address
ORA-07822sspscm: SYS$CREMBX failure
ORA-16764redo transport service to a standby database is not running
OCI-30180argument index is too large
ORA-00292parallel recovery feature not installed
ORA-54521inner ring is not inside or is touching outer ring more than once
PLS-00376illegal EXIT/CONTINUE statement; it must appear inside a loop
ORA-31475redo log catalog contains no metadata for the source table




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