I need to change the scale in NUMBER datatype that's where the issue is. NUMBER(13,2) to NUMBER(13,4).
On Tue, Apr 12, 2011 at 9:34 AM, dinesh kumar simhadri < dinesh.sm...@googlemail.com> wrote: > Alter table tablename modify varchar2(10) varchar2(20); > > i ve mentioned varchar2 as example. > Apply the same to numeric datatype. > > > On Tue, Apr 12, 2011 at 2:24 AM, swaroop gowda <swaroop.t...@gmail.com> > wrote: > > Hi, > > > > We have tables which are all partitioned and some columns has NUMBER > (13,2) > > data type and now I want to change it to NUMBER(13,4). > > The issue is that we have data in all these tables. > > > > I thought of these 2 solutions > > 1) create new table with new size NUMBER(13,4) and re-name the new table > and > > then move the partitions.Drop the old table. > > 2) create a columns with new size NUMBER(13,4) and update it, then rename > it > > later. --But all tables has over 114444012 records so it may be slow but > I > > am not sure how much slow it will be. > > > > Can any oneplease let me know if you have any better way to do this? > > > > -- > > Thanks & Regards > > Swaroop Thailuru Swamy > > Ph: 713-392-1571 > > > > -- > > You received this message because you are subscribed to the Google > > Groups "Oracle PL/SQL" group. > > To post to this group, send email to Oracle-PLSQL@googlegroups.com > > To unsubscribe from this group, send email to > > oracle-plsql-unsubscr...@googlegroups.com > > For more options, visit this group at > > http://groups.google.com/group/Oracle-PLSQL?hl=en > > > > -- > dinesh > > -- > You received this message because you are subscribed to the Google > Groups "Oracle PL/SQL" group. > To post to this group, send email to Oracle-PLSQL@googlegroups.com > To unsubscribe from this group, send email to > oracle-plsql-unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/Oracle-PLSQL?hl=en -- Thanks & Regards Swaroop Thailuru Swamy Ph: 713-392-1571 -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
