Upgrade you database to Oracle 8.0 or later and change the constraint to enable novalidate.=20 -----Original Message----- From: Seema Singh [mailto:oracledbam@xxxxxxxxxxx]=20 By fixing the data I would be able to enable constraints That I=20 know.WOndering is any way we can fix without fixing data. -- //www.freelists.org/webpage/oracle-l