Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

CLOB datatype

407048May 25 2006

I have a table in which, I have a column with datatype as BLOB. I need to alter the datatype to a CLOB
I tried
ALTER TABLE schema.table MODIFY (field CLOB)

It errored out saying
Error: ORA-22858: invalid alteration of datatype

Is there a way this can be altered (that doesn't involve a drop of the column/table) ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 22 2006

Added on May 25 2006

#general-database-discussions

0 comments

270 views