fix copy hist bug

nigelbayliss · nigelbayliss · commit e8f8c047f1f8 · 2017-03-01T11:23:16.000Z
diff --git a/optimizer/upgrading_to_12c/duplicate/copy_hist.sql b/optimizer/upgrading_to_12c/duplicate/copy_hist.sql
@@ -44,11 +44,11 @@ begin
   for t in tlist
   loop
      dbms_output.put('exec dbms_stats.set_table_prefs('''||t.owner||''','''||t.table_name||''',''METHOD_OPT'',');
-     dbms_output.put('''FOR ALL COLUMNS SIZE 1, FOR COLUMNS ');
+     dbms_output.put('''FOR ALL COLUMNS SIZE 1 FOR COLUMNS SIZE 254 ');
      tname := t.table_name;
      for c in collist
      loop
-        dbms_output.put(c.column_name||' SIZE 254 ');
+        dbms_output.put(c.column_name||' ');
      end loop;
      dbms_output.put(''')');
      dbms_output.put_line('');
diff --git a/optimizer/upgrading_to_12c/duplicate/copy_hist_a.sql b/optimizer/upgrading_to_12c/duplicate/copy_hist_a.sql
@@ -46,11 +46,11 @@ begin
   for t in tlist
   loop
      dbms_output.put('exec dbms_stats.set_table_prefs('''||t.owner||''','''||t.table_name||''',''METHOD_OPT'',');
-     dbms_output.put('''FOR ALL COLUMNS SIZE AUTO, FOR COLUMNS ');
+     dbms_output.put('''FOR ALL COLUMNS SIZE AUTO FOR COLUMNS SIZE 254 ');
      tname := t.table_name;
      for c in collist
      loop
-        dbms_output.put(c.column_name||' SIZE 254 ');
+        dbms_output.put(c.column_name||' ');
      end loop;
      dbms_output.put(''')');
      dbms_output.put_line('');
