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);