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
