Hi, all
I know the syntax to create constraint,index with the initial table creation script with tablespace storage info. I also know how to alter table add constraint primary key with tablespace storage info. I can also alter table add constraint foreign key without specifying the tablespace.But I could not get right for the alter table add constraint foreign key with tablespace storage info. I would appreciate if someone can help me with the correct syntax and give me a working example. Thanks.
The following is the foreign key I want to add. The snytax is correct, but I can not add tablespace storage into to it.
ALTER TABLE "HUBADMIN"."STEALTH_NATIVEMSG"
ADD CONSTRAINT "STEALTH_NATIVEMSG_FK" FOREIGN KEY( "DB20_ATOMICID", "DB20_HOPSTATUS")
REFERENCES "HUBADMIN"."STEALTH_HDRS"("DB20_ATOMICID","DB20_HOPSTATUS");