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

TNS-12677: Authentication service not supported by database link

1 Answers  


ORA-07552: sftget: $GET failure

1 Answers  


ORA-08434: raw data has invalid trailing sign

1 Answers  


RMAN-06081: error reading datafile header for datafile string, code string

1 Answers  


IMG-00707: unable to access image data

1 Answers  






TNS-01160: Trace level was not specified

1 Answers  


ORA-00300: illegal redo log block size string specified - exceeds limit of string

1 Answers  


TNS-04023: Command failed.

1 Answers  


TNS-12616: TNS:no event signals

1 Answers  


DRG-50902: unexpected character string

1 Answers  


ORA-27196: skgfpbk: sbtpcbackup returned error

1 Answers  


ORA-38732: Expected file size string does not match string.

1 Answers  


Categories