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
ORA-00478SMON process terminated due to error string
ORA-07277spdde: illegal pid passed as argument.
DRG-10708invalid class id string for preference string
ORA-09856smpalo: vm_allocate error while allocating pga.
ORA-32035unreferenced query name defined in WITH clause
PCC-02454Must use option OUTLINE when option OUTLINPREFIX is used
ORA-22912specified column or attribute is not a nested table type
NNC-00422invalid data type name "string"
ORA-01946DEFAULT TABLESPACE already specified
ORA-26811Client has already attached to apply "string".
ORA-16732error executing DBMS_LOGSTDBY.SKIP procedure
ORA-00490PSP process terminated with error
TNS-00517Lost contact
SQL*Loader-00104Invalid bad file name on command line
RMAN-07201Do you really want to change the above failures (enter YES or NO)?
DRG-10200invalid server personality mask: string
TNS-01090No longer listening on: string
SQL*Loader-00408Physical record stack overflow
ORA-06593string is not supported with natively compiled PL/SQL modules
ORA-01481invalid number format model




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