1 Reply Latest reply: Oct 30, 2009 10:11 PM by damorgan RSS

    Key constraints on REF

      Forigen Key constraints on nested table column:
      What can I do to prevent a REF stored in a nested table becoming dangling? I tried using a forigen key constraint on nested table column but failed with (ORA-30730: referential constraint not allowed on nested table column). Why it is not allowed?

      Unique for REF column:
      My another question is why a REF column of a table cannot be unique/ used as a primary key (ORA-02329: column of datatype REF cannot be unique or a primary key)? I want to make sure that the same REF will not appear in the column twice. What can I do?

      Thank you for the answering.