快速删除重复的记录

delete from table where rowid not in(select max(rowid) from table group by transid having count(transid)>1 );
commit;

drop index user.tablename;

create unique index   user.tablename on  user.tablename (
   TRANSID ASC
)
tablespace tablespacename ;