오라클 중복 데이터 삭제

PARTITION 을 사용하여, 중복 데이터별로 묶고, rownum을 사용하여 중복 데이터를 삭제한다

 DELETE
  FROM DBACOM.DB_SPACE_TIBERO
 WHERE ROWID IN (SELECT ROWID
 from (
 select * from (
 SELECT ROW_NUMBER() OVER(PARTITION BY savedt, host_name, trim(ts_name),autoextensible 
 order by savedt, host_name, ts_name,autoextensible ) AS num, A.*
  FROM DBACOM.DB_SPACE_TIBERO  A where savedt = '20211215'
 ) WHERE num > 1 
)