Re: What this is?

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.

Cheers
Nuno Souto
nsouto_at_bizmail.com.au
----- Original Message -----
From: "Connor McDonald" <hamcdc_at_yahoo.co.uk>

> 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.
>

--
http://www.freelists.org/webpage/oracle-l