Oracle删除表中重复数据

1.创建临时表  备份全部数据到 

CREATE TABLE TMAP.T_COMM_CUSTOMER_COL_LOG_731all AS (select * from TMAP.T_COMM_CUSTOMER_COL_LOG);

2.创建临时表  备份数据-去除重复项

CREATE TABLE TMAP.T_COMM_CUSTOMER_COL_LOG_731qcf  AS (select  distinct * from TMAP.T_COMM_CUSTOMER_COL_LOG);

3.查询数据，进行确认

select count(*) from T_COMM_CUSTOMER_COL_LOG                     560489    
select count(*) from T_COMM_CUSTOMER_COL_LOG_731all       560489
select count(*) from T_COMM_CUSTOMER_COL_LOG_731qcf      449711

4.删除正式表里面的数据

delete from TMAP.T_COMM_CUSTOMER_COL_LOG

5.将去重复项的数据插入的正式表

insert into T_COMM_CUSTOMER_COL_LOG (select * from T_COMM_CUSTOMER_COL_LOG_731qcf);