SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Alter table problem

559968Jan 8 2009 — edited Jan 8 2009

Hi,

When i used following alter table command to drop the default value, I received the 'ORA-01735: invalid ALTER TABLE option' error. Is there any workround for this ?'

SQL>

SQL> ALTER TABLE WAM_COUNTRY ALTER COLUMN COUNTRY_ID DROP DEFAULT;

ALTER TABLE WAM_COUNTRY ALTER COLUMN COUNTRY_ID DROP DEFAULT

ORA-01735: invalid ALTER TABLE option

SQL>

Edited by: user556965 on Jan 8, 2009 1:31 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 5 2009

Added on Jan 8 2009

3 comments

2,962 views