This discussion is archived
5 Replies Latest reply: Jan 18, 2013 8:50 AM by Rob_J RSS

Constraints related question

937454 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points