The Oracle (tm) Users' Co-Operative FAQ

I am unable to add a PK constraint to a table - what is the best way of finding the problem rows ?


Author's name: Connor McDonald

Author's Email: connor_mcdonald@yahoo.com

Date written: Nov 11, 2001

Oracle version(s): 8.0+

I am unable to add a PK constraint to a table - what is the best way of finding the problem rows ?

Back to index of questions


We've all been there - you issue an "alter table ... add primary key" command, and sit and watch for 12 hours whilst it chugs through your "squillion" row table only to come back with "ORA-02437: cannot validate ..." or similar because you have some problem rows. And since it failed - you are no closer to resolving the problem.

The solution is to break the task down into stages:


Further reading: N/A


Back to top

Back to index of questions