Oracle y yo

Código modificado pues me faltaron unos campos

delete  where rowid in (
select fila
 from (
select  rowid fila ,  
         , 
        row_number() 
        over (partition by -campos repetidos- 
              order by -campos repetidos- ) cantidad
  from 
      )
where cantidad > 1
   )