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!

Cannot Alter Table Column

Stalin EphraimFeb 9 2012 — edited Feb 9 2012
Hi,

Well i have table called T1 where i have some columns with 70,000 rows in that table.
now i need to change a columns datatype size from 5.2 to 5.4, with the below command.

SQL> alter table t1 modify column_name1 number(5,4);

when i execute this command i receive the below error

ORA-01440: column to be modified must be empty to decrease precision or scale

so what i did is backed up the table into another table t2 and now deleted all the rows in t1.
again i altered now the column modified successfully to (5,4)
but again when i insert the backed up table t2 into t1 i received this below error.

ORA-01438: value larger than specified precision allows for this column


the table t1 column_name1 number(5,2)
changed as column_name1 number(5,4)

now why i cant i able to insert the values into it by a backup table?

pls help.


Regards
Stanlee.
This post has been answered by Kanish on Feb 9 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 8 2012
Added on Feb 9 2012
5 comments
1,200 views