5 Replies Latest reply: Jan 18, 2013 10:50 AM by Rob_J RSS

    Constraints related question

    937454
      Hi,
      My db version:
      Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

      My questions is:
      When I open TOAD and go into the constraints tab, I see apart from the constraints that I created a lot of other system generated stuff.
      I am trying to understand, why are they created.
      Do they have any impact on the tables and other db objects.
      Can I get rid of them.

      Please see below sample of the constraints that are created automatically.
      BIN$02zvgMI6GF3gQOEKX6Mg8w==$0
      BIN$02zvgMIcGF3gQOEKX6Mg8w==$0
      FK_APPCONFIG_TO_MODEL----------------created by me
      PK_ACQUIRERREF-------------created by me
      SYS_C0014160
      SYS_C0014161