Oracle database error code ORA-01439 – column to be modified must be empty to change datatype

Oracle Database Error Code ORA-1439 Description :
column to be modified must be empty to change datatype
Error Cause:
An ALTER TABLE MODIFY statement attempted to change the datatype of a column containing data. A column whose datatype is to be altered must contain only NULL values.

How to Solve :
To alter the datatype, first set all values in the column to NULL.


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , , , ,
No Comment Yet   
«
»