Re: Alter table help

In article <d_tZ6.1419$e5.6163_at_newsfeeds.bigpond.com>, "Peta says...
>
>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
>
>
>

alter table syslogin.serial
modify user_message1 varchar2(1000) default ' ' not null;

lose the username before the column name, change the ALTER COLUMN to modify.

>
>
>
>

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp