Hi Abhay

How about disbaling the constraints and then doin somethin like this

create a table

insert /*+append*/ into new_table
select * from old table the rows you wanna kep

truncate old table


rename new_table to old table

enable constraints onec again

regards
Hrishy