Hi Naga!Are you doing "alter table tablename add columnname datatype(precision);" ? E.g: alter table client add mobile_phone varchar2(40);" ? Cheers!Oracle LazyDBA home page