Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Reducing the size of the column

unknown-2962860Jul 3 2015 — edited Jul 3 2015

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.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 31 2015
Added on Jul 3 2015
4 comments
3,449 views