Insufficient Privileges

From: Wayne Hinch <hinchy2000_at_lineone.net>
Date: Sun, 16 Mar 2003 16:26:18 +0000 (UTC)
Message-ID: <b528ja$19f$1@helle.btinternet.com>

Hi,

I am having problems creating a constraint between to tables in different schema's. The alter table command with the one constraint is below everything seems ok but i get error code ORA01031 against the stock table. I have granted the ALTER TABLE PRIVILEGE to the user i am logged in as but it still will not work.

ALTER TABLE "DOTCOM"."SUB_LIST"
 ADD (
 CONSTRAINT "SUB_LIST_STOCK" FOREIGN KEY("TPN1") REFERENCES
"SC"."STOCK"("TPN"));
 CONSTRAINT "SUB_LIST_STOCK" FOREIGN KEY("TPN1") REFERENCES
"SC"."STOCK"("TPN"))

                                                                 *

ERROR at line 3:
ORA-01031: insufficient privileges

Any help will be much appricated.

Wayne Received on Sun Mar 16 2003 - 10:26:18 CST