Alter Table help
From: Peta Griffith <peta_at_dataspeed.com.au>
Date: Sat, 21 Jul 2001 21:58:17 GMT
Message-ID: <2_tZ6.1418$e5.6118_at_newsfeeds.bigpond.com>
Date: Sat, 21 Jul 2001 21:58:17 GMT
Message-ID: <2_tZ6.1418$e5.6118_at_newsfeeds.bigpond.com>
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 Sat Jul 21 2001 - 23:58:17 CEST