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

NNO-00310: server restart countdown aborted

1 Answers  


ORA-31410: change set string is not an existing change set

1 Answers  


NNO-00634: received authoritative name "string" when we are its authority

1 Answers  


PLS-00519: This INSERT statement requires a VALUES clause containing an object type expression, not a list of values

1 Answers  


ORA-09203: sfofi: error opening file

1 Answers  






ORA-13851: Tracing for client identifier string is already enabled

1 Answers  


QSM-02147: default date format is sensitive to session settings

1 Answers  


TNS-00138: Failed to find ORACLE executable directory

1 Answers  


ORA-33084: (XSAGDNGL42) In AGGMAP workspace object, you cannot qualify the dimensioned valueset workspace object.

1 Answers  


AMD-00128: dimension #string: RDBMS parent column not specified

1 Answers  


ORA-16134: invalid MANAGED recovery FINISH option

1 Answers  


ORA-30160: Unable to access the file

1 Answers  


Categories