Oracle Database Errors or Warnings from Error ORA-02431 to ORA-02440

SQLServerF1

 

ORA-02431: cannot disable constraint (string) – no such constraint
Cause: the named constraint does not exist for this table.
Action: Obvious
ORA-02432: cannot enable primary key – primary key not defined for table
Cause: Attempted to enable a primary key that is not defined for the table.
Action: Need to add a primary key definition for the table.
ORA-02433: cannot disable primary key – primary key not defined for table
Cause: Attempted to disable a primary key tht is not defined for the table.
Action: None

ORA-02434: cannot enable unique(string) – unique key not defined for table
Cause: attempted to enable a unique key that is not defined for the table.
Action: None
ORA-02435: cannot disable unique(string) – unique key not defined for table
Cause: attempted to disable a unique key that is not deined for the table.
Action: None
ORA-02436: date or system variable wrongly specified in CHECK constraint
Cause: An attempt was made to use a date constant or system variable, such as USER, in a check constraint that was not completely specified in a CREATE TABLE or ALTER TABLE statement. For example, a date was specified without the century.
Action: Completely specify the date constant or system variable. Setting the event 10149 allows constraints like “a1 > ’10-MAY-96′”, which a bug permitted to be created before version 8.

ORA-02437: cannot validate (string.string) – primary key violated
Cause: attempted to validate a primary key with duplicate values or null values.
Action: remove the duplicates and null values before enabling a primary key.
ORA-02438: Column check constraint cannot reference other columns
Cause: attempted to define a column check constraint that references another column.
Action: define it as a table check constriant.
ORA-02439: Unique index on a deferrable constraint is not allowed
Cause: attempted to enable a deferrable primary key/unique constraint that has an existing unique index on the constraint columns.
Action: Drop the index on the constraint columns or make the constraint not deferrable.
ORA-02440: Create as select with referential constraints not allowed
Cause: create table foo (… ref. con. …) as select …;
Action: Create the table as select, then alter the table to add the constraints afterwards.

Above are list of Oracle Database Errors or Warnings from Error ORA-02431 to ORA-02440 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database.  Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *