Altering Data Length of a COLUMN
Hi Gurus,
Due to some issues in my Siebel application, I have alter a column Data Length from CHAR(1) to CHAR(5).
Now I just want to revert back to CHAR(1), when I hit the same ALTER command for decreasing the Data Length, it's giving me the following error,
SQL> alter table siebel.S_WFR_COND_VAl modify (PROCESS_EDIT_FLG char(5))
Table Altered.
SQL> alter table siebel.S_WFR_COND_VAl modify (PROCESS_EDIT_FLG char(1))
ERROR: "ORA-01441: Cannot decrease column length because some value is too big"
Note: That particular column having 'Y' or 'N' values and it's a NOTNULL, REQUIRED column.
Due to some issues in my Siebel application, I have alter a column Data Length from CHAR(1) to CHAR(5).
Now I just want to revert back to CHAR(1), when I hit the same ALTER command for decreasing the Data Length, it's giving me the following error,
SQL> alter table siebel.S_WFR_COND_VAl modify (PROCESS_EDIT_FLG char(5))
Table Altered.
SQL> alter table siebel.S_WFR_COND_VAl modify (PROCESS_EDIT_FLG char(1))
ERROR: "ORA-01441: Cannot decrease column length because some value is too big"
Note: That particular column having 'Y' or 'N' values and it's a NOTNULL, REQUIRED column.
2