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?
how?
ex--CONSTRAINT COMP_PKEY
PRIMARY KEY ( CARDID, CATEGORYID )
USING INDEX
TABLESPACE USERS PCTFREE 10
STORAGE ( INITIAL 65536 ))
TABLESPACE TOOLS
PCTFREE 10
PCTUSED 40
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 65536
MINEXTENTS 1
MAXEXTENTS 2147483645
FREELISTS 1 FREELIST GROUPS 1 )
NOCACHE;