--oracle删除数据库表（无主键）中重复的记录
1, CREATE TABLE newtable as SELECT distinct * FROM T_SYSTEM_MENU_PRIV;
2, drop table T_SYSTEM_MENU_PRIV;
3, ALTER TABLE newtable rename to T_SYSTEM_MENU_PRIV;
原文：http://www.cnblogs.com/paulen/p/7802858.html