Cannot Alter Table Column
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.