Skip to Main Content

Oracle Database Discussions

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!

Why am I getting this error message in SQL Developer-ORA-01735: invalid ALTER TABLE OPTION?

1034461Sep 8 2013 — edited Sep 8 2013

To Whom it may Concern,

I am attempting to add two columns Comm_id and Ben_id to a table in SQL Developer (Oracle).

Here is the syntax I am using:

ALTER TABLE ACCTMANAGER

ADD (Comm_id NUMBER(10)),

Ben_id VARCHAR(2);

The spool file I'm getting as a result of the script above:

Error starting at line 1 in command:

ALTER TABLE ACCTMANAGER

ADD (Comm_id NUMBER(10)),

Ben_id VARCHAR(2)

Error report:

SQL Error: ORA-01735: invalid ALTER TABLE option

01735. 00000 -  "invalid ALTER TABLE option"

*Cause:   

*Action:

DESC acctmanager

Thank you in advance.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 6 2013
Added on Sep 8 2013
1 comment
20,401 views