Oracle 8.1.7.4.0 - How to modify column from VARCHAR2 to CLOB ?
360862Aug 6 2003 — edited Aug 8 2003Hi, All !
I have Table with 420,000+ rows with has column OTHER of VARCHAR2(4000). This column is too small. I'd like to change it to CLOB. Command below gives me an error :
ALTER TABLE ERROR_LOG MODIFY OTHER CLOB;
ORA-22858: invalid alteration of datatype
I reilize that data from this column needs to be copied from existing VARCHAR2 into new CLOB datatype which has different storage structure.
How can I do this with minimal changes ?
(I know I can copy column, dropped it, add CLOB column)
Any other approach ?
Thanx a lot !
Steve K.