ORA-01735: invalid ALTER TABLE option

ORA-01735: invalid ALTER TABLE option

Oracle PL/SQL error message: ORA-01735: invalid ALTER TABLE option.

Cause:

An invalid option was specified in an ALTER TABLE statement.

Solution:

Check the statement syntax, specify a valid option, and retry the statement.

Example:

ALTER TABLE test2
ADD test_id_pk
PRIMARY KEY(test_id);

Output:

ORA-01735: invalid ALTER TABLE option




Correct

ALTER TABLE test2
ADD CONSTRAINT test_id_pk
PRIMARY KEY(test_id);

Oracle tutorial