Oracle database error code ORA-01463 – cannot modify column datatype with current constraint(s)

Oracle Database Error Code ORA-1463 Description :
cannot modify column datatype with current constraint(s)
Error Cause:
An attempt was made to modify the datatype of column which has referential constraints; or has check constraints which only allows changing the datatype from CHAR to VARCHAR or vise versa.

How to Solve :
Remove the constraint(s) or do not perform the offending operation.


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