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
