遭遇ora-30962错误

30926, 00000, "unable to get a stable set of rows in the source tables"

// *Cause:  A stable set of rows could not be got because of large dml
//          activity or a non-deterministic where clause.
// *Action: Remove any non-deterministic where clauses and reissue the dml.

merge的源表中有重复记录，去重后该错误消失。

 
    
     
         
  1. --处理重复记录 
    2.  
         
  2. SELECT userid FROM t_raugh GROUP BY userid HAVING COUNT(*) > 1; 
    3.  
         
  3.  
    4.  
         
  4. DELETE t_raugh  
    5.  
         
  5.  WHERE ID IN (SELECT a.ID 
    6.  
         
  6.                 FROM (SELECT b.id, 
    7.  
         
  7.                              b.userid, 
    8.  
         
  8.                              b.operdate, 
    9.  
         
  9.                              row_number() over(PARTITION BY b.userid ORDER BY b.operdate DESC) rn 
    10.  
         
  10.                         FROM t_raugh b 
    11.  
         
  11.                        WHERE b.userid IN (25468911, 
    12.  
         
  12.                                           25467429, 
    13.  
         
  13.                                           25464008, 
    14.  
         
  14.                                           25466351, 
    15.  
         
  15.                                           25464129, 
    16.  
         
  16.                                           25464805, 
    17.  
         
  17.                                           25468403, 
    18.  
         
  18.                                           25466240, 
    19.  
         
  19.                                           25467371, 
    20.  
         
  20.                                           25467777, 
    21.  
         
  21.                                           25464193, 
    22.  
         
  22.                                           25468734, 
    23.  
         
  23.                                           25464215, 
    24.  
         
  24.                                           25464596, 
    25.  
         
  25.                                           25467334, 
    26.  
         
  26.                                           25459985, 
    27.  
         
  27.                                           25468964, 
    28.  
         
  28.                                           25464928, 
    29.  
         
  29.                                           25469118, 
    30.  
         
  30.                                           25465790, 
    31.  
         
  31.                                           25466484, 
    32.  
         
  32.                                           25467080, 
    33.  
         
  33.                                           25468491, 
    34.  
         
  34.                                           25469197, 
    35.  
         
  35.                                           25467072, 
    36.  
         
  36.                                           25468492, 
    37.  
         
  37.                                           25467930, 
    38.  
         
  38.                                           25466768, 
    39.  
         
  39.                                           25463448, 
    40.  
         
  40.                                           25467653, 
    41.  
         
  41.                                           25468505, 
    42.  
         
  42.                                           25464075, 
    43.  
         
  43.                                           25468870, 
    44.  
         
  44.                                           25468971, 
    45.  
         
  45.                                           25467491)) a 
    46.  
         
  46.                WHERE a.rn > 1) 
    47.