having to do with machinery: a mechanical failure. 2. being a machine; operated by machinery: a mechanical toy. 3. caused by or derived from machinery: mechanical propulsion.
ERROR: cannot alter type of a column used by a view or rule DETAIL: rule _RETURN on view v_change_me depends on column too_short. Though PostgreSQL tells us which view and column prompted this error, thatâs the last favor it provides.
ORA-22859: invalid modification of columns. I have an Oracle table with a column of type clob. I want to preserve the column order and change the datatype to a varchar2. The column just contains text. I'm getting the standard message: ORA-22859: invalid modification of columns. I have tried making the column null and then converting to char or long, then to varchar2. But nothing seems to be working. I would prefer to not have to copy the table to change the one column. I don't just want to read the contents.