3 Replies Latest reply: Nov 29, 2012 1:31 PM by Chrisjenkins-Oracle RSS

    How to create cache group for many to many relationship tables?

    914264
      Hi, Chris,
      On page 4-4 in <<Oracle In-Memory Database Cache User's Guide>> there is a saying,
      A child table cannot reference more than one parent table.
      If there is a many-to-many relationship table in Oracle and I want to cache it in TT, there is no approach to map that?
      Or I have to logically break its references to the two tables to the one of them?
      I forget to mention that I have a root table and one of its child tables is a many-to-many relationship table.