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@xxxxxxxxxxxxxx ----- 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. > -- //www.freelists.org/webpage/oracle-l