Tuesday, March 3, 2015

[SOLVED] ORA-01439: column to be modified must be empty to change datatype

ISSUE

ORA-01439: column to be modified must be empty to change datatype

REASON

This error may occur on below cases.

1. modify the data type for the LONG column
2. renaming the LONG column name