Add PK constraint using index tablespace

Programming
,
1

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?

2

The error is caused by the redundant use of the “USING INDEX” clause. Remove the line “USING INDEX TABLESPACE OPS;” and the ALTER TABLE statement should work.

Here’s the corrected code:

ALTER TABLE OPS.F4111 ADD CONSTRAINT F4111_PK PRIMARY KEY (ILUKID) USING INDEX OPS.F4111_0;