SAP Knowledge Base Article - Preview

2215761 - Error ORA-22858 modifying column data type to CLOB - SAP PowerDesigner

Symptom

  • Data type of an Oracle table column is modified to CLOB.
  • PowerDesigner generates an ALTER TABLE table_name MODIFY column_name statement.
  • Executing the script generated by PowerDesigner leads to error "ORA-22858 - invalid alteration of datatype".
  • The alter.sql file must drop then create the table again.


Read more...

Environment

  • SAP PowerDesigner 16.5
  • Oracle DBMS

Product

SAP PowerDesigner 16.5

Keywords

table, Oracle, blob, clob, lob, drop, create, alter, change  , KBA , BC-SYB-PD , PowerDesigner , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.