Hi all,
have a table like :
create table test(col1 varchar2(20),col2 number); -- with data
now i have to change col1 to clob.
alter table test
modify col1 clob; ... is not working..
can i change the data type to clob without dropping the table .. as it contains huge data.. i will take a lot of time repopulating it..