Hi, Correct. Look at the example of dbms_redefinition. It is old but the idea applies. http://www.dbspecialists.com/files/presentations/online_redef.html Regards, On Fri, Jun 1, 2012 at 9:48 PM, Rui Cat <rui_catcuddler@xxxxxxxxx> wrote: > As Mark and Tim showed not directly. Maybe looking at the > dbms_redefinition package might help in this instance. > Rui > > > ________________________________ > From: "Zelli, Brian" <Brian.Zelli@xxxxxxxxxxxxxxx> > To: oracle-l <oracle-l@xxxxxxxxxxxxx> > Sent: Friday, June 1, 2012 1:51:16 PM > Subject: changing a column type > > A colleague wants to change a column type from numeric to alpha-numeric. > Can he change it with data in it? > > ciao, > Brian > > Brian Zelli > Senior Database Administrator > Enterprise Applications/Systems Integration > Roswell Park Cancer Institute > (716) 845-4460 > brian.zelli@xxxxxxxxxxxxxxx > > > > This email message may contain legally privileged and/or confidential > information. If you are not the intended recipient(s), or the employee or > agent responsible for the delivery of this message to the intended > recipient(s), you are hereby notified that any disclosure, copying, > distribution, or use of this email message is prohibited. If you have > received this message in error, please notify the sender immediately by > e-mail and delete this email message from your computer. Thank you.-- > //www.freelists.org/webpage/oracle-l > -- > //www.freelists.org/webpage/oracle-l > > > -- //www.freelists.org/webpage/oracle-l