SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need to change Column datatype having data

457512Dec 2 2005 — edited Dec 5 2005

Hi Friends,

I need to change the column datatype from number(38) to varchar2(10), which is also a primary key and it may have some refernces and is also having some data.
According to me , first i need to update all the values to null
And then i need to change the datatype

But Here as the column is primary key , How can we update all the rows to null,
And what is the Procedure i need to follow such that i should not loose any data.

As for me i am creating duplicate and i want to restore after altering the datatype, but what about the referncing tables?
Please Get me out from this situation thank you

Thanks
Rajdeep.A

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 2 2006

Added on Dec 2 2005

9 comments

403 views