在oracle里面生产所有的主键定义，然后到达梦中执行一下

  select a.constraint_name, 
         a.TABLE_NAME, 
         count(a.constraint_name), 
         concat('alter table ', concat(a.TABLE_NAME,concat(' add constraint ',concat(a.constraint_name , concat(' primary key (',concat(wmsys.wm_concat(a.column_name),');'))))))
    from user_cons_columns a, 
         user_constraints b 
   where a.constraint_name = b.constraint_name 
     and b.constraint_type = 'P'
    -- and a.table_name in ( '表名1', '表名2') 
group by a.constraint_name, 
         a.TABLE_NAME

用listagg排一下序更好一点，能保证组合主键列的顺序一致性

  select a.constraint_name, 
         a.TABLE_NAME, 
         count(a.constraint_name), 
         concat('alter table ', concat(a.TABLE_NAME,concat(' add constraint ',concat(a.constraint_name , concat(' primary key (',concat(listagg(a.column_name,',') within group(order by a.column_name),');'))))))
    from user_cons_columns a, 
         user_constraints b 
   where a.constraint_name = b.constraint_name 
     and b.constraint_type = 'P'
    -- and a.table_name in ( '表名1', '表名2') 
group by a.constraint_name, 
         a.TABLE_NAME