ORA-02446: CREATE TABLE ... AS SELECT failed - check
constraint violated



ORA-02446: CREATE TABLE ... AS SELECT failed - check constraint violated..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-12477: greatest lower bound resulted in an invalid OS label

1 Answers  


ORA-13437: GeoRaster metadata blocking error

1 Answers  


LSX-00238: invalid Nmtoken "~S"

1 Answers  


ORA-30734: cannot specify scope constraint on ref column with rowid

1 Answers  


ORA-37007: (AWLISTALL05) number writer

1 Answers  






NNL-00930: Requests refused, unknown data type: number

1 Answers  


RMAN-10001: error parsing recovery catalog connect string "string"

1 Answers  


LPX-00208: unknown DTD keyword "~s"

1 Answers  


LSX-00166: both content types must be mixed or both must be element-only

1 Answers  


SQL-02118: Invalid row for a WHERE CURRENT OF operation

1 Answers  


ORA-12229: TNS:Interchange has no more free connections

1 Answers  


ORA-40004: penalty must be negative for BLAST-N

1 Answers  


Categories