303: execute immediate l_stmt;
304: commit;
305:
306: --bug fix 3355535
307: DBMS_STATS.GATHER_TABLE_STATS(l_owner,l_sob_vset_lookup_table);
308:
309: logTime('Creating SOB-Value_set Lookup Table', l_log_timstamp);
310:
311: exception
358: execute immediate l_stmt;
359: commit;
360:
361: --bug fix 3355535
362: DBMS_STATS.GATHER_TABLE_STATS(l_owner,l_value_set_temp_table);
363:
364: logTime('Creating Value_set Temp table', l_log_timstamp);
365: exception
366: when others then
435: execute immediate l_stmt;
436: VBHDEBUG('Created index on '||g_hie_temp_table_name||'(flex_value_set_id)');
437: commit;
438: --bug fix 3355535
439: DBMS_STATS.GATHER_TABLE_STATS(l_owner,l_hie_temp_table_name);
440:
441: logTime('Creating hierarchy temp table', l_log_timstamp);
442: exception
443: when others then
517:
518: commit;
519:
520: --bug fix 3355535
521: DBMS_STATS.GATHER_TABLE_STATS(l_owner,l_value_temp_table);
522:
523: logTime('Creating value temp table', l_log_timstamp);
524: exception
525: when others then
690: VBHDEBUG('');
691: execute immediate l_stmt;
692:
693: --bug fix 3355535
694: DBMS_STATS.GATHER_TABLE_STATS(l_owner,l_source_temp_table_name);
695:
696: EXCEPTION
697: WHEN OTHERS THEN
698: l_errbuf :=sqlerrm;
920:
921: commit;
922:
923: --bug fix 3355535
924: DBMS_STATS.GATHER_TABLE_STATS(l_owner,l_value_orp_dup_table);
925:
926: logTime('Creating orphan value duplication holder table', l_log_timstamp);
927: exception
928: when others then
1023:
1024: commit;
1025:
1026: --bug fix 3355535
1027: DBMS_STATS.GATHER_TABLE_STATS(l_owner,l_value_con_dup_table);
1028:
1029: logTime('Creating consolidation value duplication holder table', l_log_timstamp);
1030: exception
1031: when others then