Re: Alter table help

Hello Peta,

If I understand what you are trying to do you need to do somethign like this:

alter table sylogin.SERIAL
 modify USER_MESSAGE1 varchar2(1000) default '' not null;

On Mon, 25 Jun 2001 08:53:41 +1000, "Peta Griffith" <peta_at_dataspeed.com.au> wrote:

>When using this statement:
>
>ALTER TABLE sylogin.SERIAL ALTER COLUMN sylogin.USER_MESSAGE1 VARCHAR2
>(1000) DEFAULT ' ' NOT NULL
>
>we use the Oracle Provider and this error is returned:
>
>ORA-01735: invalid ALTER TABLE option
>
>
>
>
>
>
Received on Sun Jun 24 2001 - 19:17:25 CDT