Re: create three column unique constraint on existing table

Yes,

1. execute the utlexcpt.sql script in $ORACLE_HOME/rdbms/admin/ directory.
2. Create the constraint:

ALTER TABLE BIG_TABLE ADD CONSTRAINT BIG3_CONSTRAINT UNIQUE (col1, col2, col3)

EXCEPTIONS INTO EXCEPTIONS ..etc...

;

Then all duplicate rows will be recorded in the EXCEPTIONS table.

:cool:

--
Posted via http://dbforums.com