Oracle Database Discussions

Hi All,

I am changing one of the fields/columns in my existing DB's table which has data inside. I am changing the data type from BYTE to CHAR for this column, without changing the length of this column. Example, changing VARCHAR2(80 BYTE) to VARCHAR2(80 CHAR).

My question is that, after I change the data type, should I drop and rebuild all the indexes which are related to this changed column? if so, should I do it in this sequence?:

Drop index, Alter table column data type, create indexes.

Can anybody provide me some ideas? And is there any Oracle doc saying about this?


Thanks.