Alter table

From: as <jetta6NOjeSPAM_at_netscape.net.invalid>
Date: 2000/07/26
Message-ID: <2798f700.21e16119@usw-ex0102-084.remarq.com>#1/1

I am trying to alter a table with LONG datatype but getting the following error:

SQL> ed
Wrote file afiedt.buf

  1 alter table person_involve
  2 modify
  3* (RESEARCH_PRO_EXPERIENCE CLOB)
SQL> /
(RESEARCH_PRO_EXPERIENCE CLOB)
*
ERROR at line 3:
ORA-22858: invalid alteration of datatype

Does it mean that I have to recreate the table?

Thanks in advance.

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Wed Jul 26 2000 - 00:00:00 CDT