Hi,
My requirement is that I have a table named employee and in which the emp_name is the column which is of datatype varchar2(50) at the beginning.
Then am modifying the column size to varchar2(100) as per the requirement.
And afterwards my requirement again changed and I have to reduce the size of the column again to varchar2(50) but I can't able to do it and am getting the error.
The error is ORA-01441: cannot decrease column length because some value is too big
I want to know the way to solve this issue.
Regards,
Vinoth.