Changing datatype of columns without dropping associated constraints

Hello,

I have two tables...P_TYPE and AC_PROJECT

P_TYPE(table)

p_type_code varchar2(2) Primary Key --column
......
......

AC_TYPE(table)

ac_type_code varchar2(2) Primary Key --column p_type_code varchar2(2) Foreign Key relation to p_type_code in P_TYPE table.

Now I want to change the datatype of the p_type_code to char(2) in both the tables P_TYPE and AC_TYPE without dropping the constraint.

Will disabling the constraint allow me to change the datatype of the columns?

Thanks

Pinaki Received on Fri Feb 13 2004 - 04:58:56 CST