这个网址可以作为参考
http://forums.oracle.com/forums/thread.jspa?threadID=1114905&start=0&tstart=0
这个问题有可能是在Merge 时出现了重复的记录
我在做记录优化时遇到了这个问题unable to get a stable set of rows in the source tables 。
通过上边的网站,有人提出“AFAIK it can't be possible without unique key or primary key”
我判断问题是出现了重复的记录
在做优化时,我修改了如下内容:
select distinct customer_id,member_id from xxx where is_deleted is 'n';
结果出现了两条重复的记录。
修改成
(select customer_id,member_id from
(
SELECT customer_id,member_id,row_number()
OVER(PARTITION BY customer_id ORDER BY GMT_MODIFIED DESC ) AS rw
FROM xxx WHERE is_deleted = 'n'
)where rw = 1) t7
查出最新的那条记录,去掉重复记录。问题解决了。