How to change precision after data is loaded ?
626351Apr 27 2009 — edited Apr 27 2009I have a table with 4 columns defined as straight "NUMBER" but contain floating point values. I need to alter the table by defining a precision on the fields. The existing data should match the precision I am trying to alter the table to, but I am still getting the following error:
ORA-01440: column to be modified must be empty to decrease precision or scale
The syntax I used to alter the table was:
alter table rpf_cib_resolved modify("MIN_LAT" number(8,6));
I hope there is a trick or work around to modify the precision without having to truncate the table....
Vicki