Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> what permission are needed to have constrainst across schemas?
I have given select, update, delete, doesn't work.
Thanx
1 CREATE TABLE sw.manager_tourn (
2 user_id NUMBER(10) REFERENCES sw.users (id) 3 ON DELETE CASCADE, 4 tourn_id NUMBER(5) REFERENCES stat.tournament (id) 5 ON DELETE CASCADE, 6 score NUMBER(3), 7 CONSTRAINT manager_tourn_pk PRIMARY KEY (user_id, tourn_id) 8 USING INDEX TABLESPACE swind tourn_id NUMBER(5) REFERENCES stat.tournament (id) *ERROR at line 4:
Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 750-3630 AOL: NetComrade ICQ: 11340726 remove NSPAM to emailReceived on Tue Mar 14 2000 - 00:00:00 CST