I am trying to run the following code to add a primary key constraint to a table:
ALTER TABLE OPS.F4111 ADD CONSTRAINT F4111_PK PRIMARY KEY ( ILUKID ) USING INDEX OPS.F4111_0 USING INDEX TABLESPACE OPS;
However, I am getting the following error: 01735. 00000 - “invalid ALTER TABLE option”.
What is causing this error?