The statements below don't seem to work. I get "New size specified for
column VAL must be at least 10000 characters." in step 3.

> 2. Update the entire table like this:
>
> UPDATE ATABLE
> SET YOUR_VARCHAR_COL = SUBSTRING(YOUR_VARCHAR_COL FROM 1 FOR 200);
>
> COMMIT;
>
> 3. ALTER TABLE ATABLE
> ALTER COLUMN YOUR_VARCHAR_COL
> TYPE VARCHAR(200);
> COMMIT;
>