ORA-02446: CREATE TABLE ... AS SELECT failed - check constraint violated
Cause: An attempt was made to use a CREATE TABLE ... AS SELECT statement when some rows violated one or more CHECK constraints.
Action: Do not select rows that violate constraints.
ORA-02447
Custom Search


More Oracle errors
OCI-31181PL/SQL DOM handle accesses node that is no longer available
EXP-00083The previous problem occurred when calling string.string.string
ORA-39183internal error string ocurred during decompression phase string
ORA-53215cannot access ORDDataSource object with invalid source type
ORA-00439feature not enabled: string
O2I-00101Invalid value for the USERID parameter
ORA-19166FONS0003: FONS0004: no namespace found for prefix
KUP-04062no data source specified
ORA-31019Recursive deletion snapshot too old for string/string
NCR-00003NCR: Initialization failure
NNL-01071Command-line parameter file name: string
EXP-00080Data in table "string" is protected. Using conventional mode.
LCD-00218error in file [string]
PLS-00636overriding method requires OVERRIDING keyword
NNL-01054Request forwarding enabled: string
ORA-36778(XSPGTRLOW) The amount of available temporary storage is still low. Free some temporary storage immediately. You can do so, for example, by UPDATING or DETACHING an analytic workspace.
ORA-28553pass-through SQL: invalid bind-variable position
RMAN-06212Object Type Filename/Handle
ORA-27480window "string" is currently open
ORA-02397exceeded PRIVATE_SGA limit, you are being logged off




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-02446CREATE TABLE ... AS SELECT failed - check constraint violated