Re: changing a column type

From: Guenadi Jilevski <gjilevski_at_gmail.com>
Date: Fri, 1 Jun 2012 21:56:27 +0300
Message-ID: <CADFytLhCMfxLVjgaUe-MdMwF2dB2UQmsPAdpaoF48T4PhbehRQ_at_mail.gmail.com>

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_at_yahoo.com> 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_at_RoswellPark.org>
> To: oracle-l <oracle-l_at_freelists.org>
> 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_at_roswellpark.org
>
>
>
> 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.--
> http://www.freelists.org/webpage/oracle-l
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jun 01 2012 - 13:56:27 CDT