Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> No foreign key allowed in type?
We have a many to many join situation, and were thinking of speeding it up by having a varray of types in one of the tables containing all of the join information. However, it doesn't appear that foreign keys are allowed in object types.. Is this correct?
Is there another way arround this?
Specifics
Table A (id number, etc.,)
Table B (id number, etc.,)
Join table
Table C (Aid, Bid)
We'd like to add an object type to A in a varrary that could contain several foreign key references like
create type xyz as object
(a VARCHAR2(30),
b number, contraint xyz foreign key (b) references B(id);
Any possibilities in the new object-relational world?
![]() |
![]() |