delete dublicate rows

drop table orhan.personel;

create table orhan.personel (id number,adi varchar2(20),gorevi varchar2(50));

insert into orhan.personel (id,adi,gorevi) values (10,’orhan’,’dba’);
insert into orhan.personel (id,adi,gorevi) values (20,’ahmet’,’hizmetci’);
insert into orhan.personel (id,adi,gorevi) values (10,’orhan’,’dba’);
insert into orhan.personel (id,adi,gorevi) values (20,’ahmet’,’hizmetci’);
insert into orhan.personel (id,adi,gorevi) values (10,’orhan’,’dba’);

delete from orhan.personel where rowid not in (select min(rowid) from orhan.personel group by id);
—————————————————
7 gb a kadar artan rollback segmentlerde duplica kayıtları silmek için;

delete from orhan.personel where rowid in
(select rid from (select rowid rid, row_number() over (partition by id order by rowid) rn from orhan.personel )where rn 1 );