Re: What this is?

  • From: "Nuno Souto" <nsouto@xxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Sun, 14 Nov 2004 18:56:40 +1100

You forgot the AVCON* constraints...
The unload/reload: yeah, classic.  The problem could be
alleviated if Oracle had an option to not auto-generate
constraint names.  I don't think there is anything in
the SQL standard that says they can be auto-generated.
Doing so exposes users to errors like this.
I'd rather Oracle didn't, quite frankly: it would *force*
people to use correct practices.

Nuno Souto
----- Original Message ----- 
From: "Connor McDonald" <hamcdc@xxxxxxxxxxx>

> Another thing to look for is the (poor) practice of people leaving their 
> check constraints with
> auto-generated names (SYS_C....).  When you export/import et al, you can 
> get 'n' copies of the
> same constraint.


Other related posts: