Add Constraints to Existing Table[Oracle DBA]

Constraint Added with Exceptions Into

To create a unique constraint, just replace the primary key clause with unique. When you attempt to create a unique index on a table that already has data in it, the command will fail if any duplicates exist. If the create unique index statement succeeds, any future attempt to insert (or update) a row that would create a duplicate key will fail and result in this error message

ERROR at line 1:
ORA-00001: unique constraint (BOOKSHELF_AUTHOR.BA_PK) violated

1) The AUCTION_ID table contains a duplicate a value in the AUCTION_ID column. — The AUCTION_ID table contains a duplicate a value in the AUCTION_ID column.

2) A PRIMARY KEY constraint is added to the AUCTION_ID column with the EXCEPTIONS INTO clause. — A PRIMARY KEY constraint is added to the AUCTION_ID column with the EXCEPTIONS INTO clause.

3) The ROWID of the offending row is written to the EXCEPTIONS table, along with other identifying information — The ROWID of the offending row is written to the EXCEPTIONS table, along with other identifying information.