Oracle DBA, How To, Error, Cause and Action

ORA-01463: cannot modify column datatype with current constraint(s)

ORA-01463: cannot modify column datatype with current constraint(s)


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.



Action:


Remove the constraint(s) or do not perform the offending operation.

No comments:

Post a Comment

Thanks for your comment.