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

ScottHughes · 10-12-2006

Blob or Clob?

In mySQL, I use Blob not Clob.

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

10-12-2006	#2 (permalink)
ScottHughes Senior Member Join Date: Sep 2006 Age: 22 Posts: 460	Re: Modify table datatype from VARCHAR2(4000) to CLOB Blob or Clob? In mySQL, I use Blob not Clob. __________________ Online Book Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Get rid of extents on table and index	kevin	Site and Server Administration	0	07-29-2006 05:51 PM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

	All times are GMT. The time now is 11:01 AM.
	Contact Us - preCharge.Net - Archive - Privacy Statement - Top