preCharge Forums - View Single Post - Modify table datatype from VARCHAR2(4000) to CLOB

jason · 08-01-2006

Gurus,

I'm trying to modify a datatype from varchar2 (4000) to Club in one of my tables and I'm getting the following error:

alter table gls_attr modify (attr_value CLOB);

ORA-22858: invalid alteration of data type

I'm on 10G, shouldn't this work
thanks
jason

08-01-2006	#1 (permalink)
jason Junior Member Join Date: Jul 2006 Age: 33 Posts: 27	Modify table datatype from VARCHAR2(4000) to CLOB Gurus, I'm trying to modify a datatype from varchar2 (4000) to Club in one of my tables and I'm getting the following error: alter table gls_attr modify (attr_value CLOB); ORA-22858: invalid alteration of data type I'm on 10G, shouldn't this work thanks jason