Hiii,I have table it is stored in tools tablespace but it's primary key constraint is stored in some other table space.
So,Now i like move primary key constraint from users tables to tools space?
PRIMARY KEY ( CARDID, CATEGORYID )
TABLESPACE USERS PCTFREE 10
STORAGE ( INITIAL 65536 ))
FREELISTS 1 FREELIST GROUPS 1 )
Re-create the constraint (like your example), specifying the correct tablespace, which will then create the index in the correct place.
Remember that it is the index that is asociated with the primary key constraint that gets stored there. The constraint itself is just a rule that Oracle needs to enforce, and is stored in the data dictionary.