ORA-01441 cannot decrease column length because some value is too big

  • Share
  • Share

Description:
ORA-01441 cannot decrease column length because some value is too big

Cause:
An ALTER TABLE MODIFY statement attempted to decrease the size of a character field containing data. A column whose maximum size is to be decreased must contain only NULL values.

ORA-00900 to ORA-01499 , , , , , , , , , , , , , , , , ,

  1. admin
    March 20th, 2009 at 13:46 | #1

    Set all values in column to NULL before decreasing the maximum size.

  1. No trackbacks yet.