constraints

[Guest]

hi
if we disable a primary key constraint and we have invalid values in primary key column and then we enable it no validate then oracle returns an error...and oracle says that if u have nonunique index on ur primary key column then u can enable constraint novalidate....kindly someone tell me that how can we create a nonunique constraint explicitely because i didnt see syntax for this anywhere
Regards

[Tim...]

Hi.

You need to drop the primary key, create a non-unique index on the table, then create the primary key telling it o use the non-unique index, then you disable no-validate it.

Cheers

Tim...

[Guest]

hi
well these things i already know, the question was that how to create non-unique index???is it the case that whn we create an index on a non key columns, it is non unique or is there some command that we use to creae a nonunique index
Regards

[Tim...]

Hi.

CREATE INDEX ....
CREATE UNIQUE INDEX ....

Simple as that.

Cheers

Tim...