Re: ORA-00001: unique constraint violated

Hello Howard,

wow ... you impress me ... and I agree in most things with you ... but look at the create table statement of for example a 9i database and you will see that you can define primary key constraints directly when creating the table .... this will automatically create a primary unique index of course .... most people forget to give this thing a name and therefor the constraint is named something like sys...., because it is a automatically generated system name ....

As for my knowledge the create index command is still there and works of course, but the techique to build it up is a constraint. But I was only talking about the standard behavior ... not the exceptions or the later add ons.

The normal way it works is that the index then will be dropped or recreated ... about the sense to keep an index when you manipulate a table with disabled constraints ... hm ... i fear this is another discussion.

Greetings,
Michael

ps: I'm really not perfect and I might be wrong, but I'm able to learn day for day .... :-) Received on Wed Nov 17 2004 - 01:47:59 CST