It's easy to introduce duplicate rows of data into Oracle tables by running a data load twice without the primary key or unique indexes created or enabled.
Here's how you remove the duplicate rows before the primary key or unique indexes can be created:
DELETE FROM our_table
WHERE rowid NOT IN
(SELECT MIN(rowid)
FROM our_table
GROUP BY column1, column2, column3... ;
Here column1, column2, column3 constitute the identifying key for each record.
Be sure to replace our_table with the table name from which you want to remove the duplicate rows. The GROUP BY is used on the columns that make the primary key for the table. This script deletes each row in the group after the first row.
分享到:
相关推荐
Oracle 11gR2 使用 RMAN duplicate from active database 复制数据库
duplicate绝对干货。利用duplicate复制数据库,文档中包换每一步的试验步骤,详细说明了每一步的作用及用途,和注意事项,一步一步至试验成功,绝对一次成功。
Oracle RMAN DUPLICATE教程
某公司实施文档记录,非常珍贵的资料,通过duplicate实现oracle dataguard环境的搭建,需要的请下载。
Oracle Rman Active Database Duplicate 迁移方案V1.1.pdf
Oracle 11g RAC-RAC DG Duplicate搭建(生产操作文档)Oracle 11g RAC-RAC DG Duplicate搭建(生产操作文档)
This document will cover the process to duplicate an Oracle 10g database on another server using a Galaxy backup. This document should in no way be treated as the “End All” procedure. It is merely ...
Oracle 11gR2 dataguard搭建说明
帮助你删除目录中重复的文件,很有用的小工具。
使用RMAN DUPLICATE...FROM ACTIVE DATABASE 创建物理备库 简化standby创建过程,提高效率
RMAN高级应用之Duplicate复制数据库
Oracle DataGuard搭建通过duplicate
删除文件夹下相同的文件 博客: 【python中级】 基于md5值的图片去重工具 https://blog.csdn.net/jn10010537/article/details/118784182
3. Remove any product identification, copyright, proprietary notices or labels from Vistanita Duplicate Finder. 4. Distribute, re-distribute, rent, lease or sell the licensed version of Vistanita ...
The number of levels in an index will vary depending on the number of rows in the table and the size of the key column or columns for the index. If you create an index using a large key, fewer ...
14 ADG ORACLE 11G DATAGUARD 搭建(RMAN duplicate方式-相同目录结构) 15 ADG oracle 11g rac+单机dataguard实施文档(详细) 16 ADG Oracle 11g:ORACLE ACTIVE DATA GUARD 17 ADG Oracle 11gR2 使用copy 数据...
Fast Duplicate File Finder
FirmTools Duplicate Photo Finder 相似图像查询软件 你电脑中如果有很多图像,有很多可能是一个logo只差,你用其他md5检测软件是不能快速找出来的。这个软件可以搜索相似的图像,你查看后选择删除,非常的方便。 ...
duplicate cleaner pro 破解版 4.0.5 。安装后,将第二步的x86及x64目录下的文件拷贝到安装目录下的x86与x64下。然后启动,输入长一点的序列号(随便输入字符),即可破解。
Rman通过duplicate创建standby