WHEN WE UPDATE POLICYFROM DATABASE it gives error ora 00001,
we tried to run following command
delete from misctbltmpmedgrpdtls where rowid not in (select min(rowid) from misctbltmpmedgrpdtls group by num_serial,dat_from_date)
/
it gives error ora 00904
pls advise.