ORA-02447: cannot defer a constraint that is not deferrable
Cause: An attempt was made to defer a nondeferrable constraint
Action: Drop the constraint and create a new one that is deferrable
ORA-02448
Custom Search


More Oracle errors
PLS-00619the first operand in the NULLIF expression must not be NULL
ORA-02716osnpgetdatmsg: message from host had incorrect message type
ORA-06555this name is currently reserved for use by user SYS
TNS-01003status [<listener_name>] : get the status of listener
ORA-13647Setting of parameter string is disallowed during task execution.
ORA-00481LMON process terminated with error
ORA-31444parameter error while acquiring lock on string
TNS-01406ID: string
UDI-00003all allowable logon attempts failed
ORA-08181specified number is not a valid system change number
PLW-06007procedure "string" is removed because optimization removed calls
ORA-13007an invalid HEX character was detected
ORA-24775cannot prepare or commit transaction with non-zero lock value
RMAN-05532PASSWORD FILE specified without FROM ACTIVE DATABASE
ORA-19591backup aborted because job time exceeded duration time
PLW-05008illegal number of arguments for pragma string
TNS-01112Plug and play can either be ON or OFF
DRG-50943query token too long on line string on column string
ORA-02146SHARED specified multiple times
ORA-10663Object has rowid based materialized views




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-02447cannot defer a constraint that is not deferrable