I'm trying to remove column from DB and got a strange error:
Error starting at line 147 in command: alter table config drop column dte Error report: SQL Error: ORA-12899: value too large for column "OWNER"."CONFIG"."DTE" (actual: 3, maximum: 1) 12899. 00000 - "value too large for column %s (actual: %s, maximum: %s)"
*Cause: An attempt was made to insert or update a column with a value which is too wide for the width of the destination column. The name of the column is given, along with the actual width of the value, and the maximum allowed width of the column. Note that widths are reported in characters if character length semantics are in effect for the column, otherwise widths are reported in bytes.
*Action: Examine the SQL statement for correctness. Check source and destination column data types. Either make the destination column wider, or use a subset of the source column (i.e. use substring).
I don't have triggers on this table. Could anyone advice on it? Thanks!
UPD: we were able to delete it using alter table ... set unused ... and alter table drop unused columns after it. But still have no idea why simple drop doesn't work.