db-ddlutils-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Robert Björn" <rob...@objective.se>
Subject Re: Unique constraint in Oracle not getting created
Date Mon, 01 Oct 2007 20:51:55 GMT
I think that I found the solution to this problem. I had to

a) Remove other apparently redundant indices first
b) Give my unique index a name, otherwise it looks like DdlUtils skips
it over (even though it's not supposed to be mandatory?)

> I'm trying to get a unique constraint (airline_static_id) to be added to my
> Oracle table during creation but for some reason, it does not appear to get
> added – I see no SQL commands adding it or specifying it in the CREATE
> statement, and I can violate the constraint in the resulting database
> without anything stopping me.

Regards,
Robert

Mime
View raw message