At 01:05 PM 21/01/2005 +0000, you wrote:

>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;
> >

OK, then you need to use the temporary column method described by Dmitry.

Helen