25: bis_collection_utilities.put_line('The degree of parallelism is ' ||
26: l_parallel_degree ) ;
27:
28: line:='5' ;
29: oki_dbi_mv_util_pvt.refresh( p_mv_name => 'oki_scm_01_j_mv'
30: , p_parallel_degree => l_parallel_degree ) ;
31: bis_collection_utilities.put_line('MV: oki_scm_01_j_mv refreshed.') ;
32:
33: line:='10' ;
30: , p_parallel_degree => l_parallel_degree ) ;
31: bis_collection_utilities.put_line('MV: oki_scm_01_j_mv refreshed.') ;
32:
33: line:='10' ;
34: oki_dbi_mv_util_pvt.refresh( p_mv_name => 'oki_scm_ocr_mv'
35: , p_parallel_degree => l_parallel_degree ) ;
36: bis_collection_utilities.put_line('MV: oki_scm_ocr_mv refreshed.') ;
37:
38: line:='15' ;
35: , p_parallel_degree => l_parallel_degree ) ;
36: bis_collection_utilities.put_line('MV: oki_scm_ocr_mv refreshed.') ;
37:
38: line:='15' ;
39: oki_dbi_mv_util_pvt.refresh( p_mv_name => 'oki_scm_o_1_mv'
40: , p_parallel_degree => l_parallel_degree ) ;
41: bis_collection_utilities.put_line('MV: oki_scm_o_1_mv refreshed.') ;
42:
43: line:='20' ;
40: , p_parallel_degree => l_parallel_degree ) ;
41: bis_collection_utilities.put_line('MV: oki_scm_o_1_mv refreshed.') ;
42:
43: line:='20' ;
44: oki_dbi_mv_util_pvt.refresh( p_mv_name => 'oki_scm_o_2_mv'
45: , p_parallel_degree => l_parallel_degree ) ;
46: bis_collection_utilities.put_line('MV: oki_scm_o_2_mv refreshed.') ;
47:
48: line:='25' ;
45: , p_parallel_degree => l_parallel_degree ) ;
46: bis_collection_utilities.put_line('MV: oki_scm_o_2_mv refreshed.') ;
47:
48: line:='25' ;
49: oki_dbi_mv_util_pvt.refresh( p_mv_name => 'oki_scm_ot_mv'
50: , p_parallel_degree => l_parallel_degree ) ;
51: bis_collection_utilities.put_line('MV: oki_scm_ot_mv refreshed.') ;
52:
53: line:='30' ;
50: , p_parallel_degree => l_parallel_degree ) ;
51: bis_collection_utilities.put_line('MV: oki_scm_ot_mv refreshed.') ;
52:
53: line:='30' ;
54: oki_dbi_mv_util_pvt.refresh( p_mv_name => 'oki_scm_blg_mv'
55: , p_parallel_degree => l_parallel_degree ) ;
56: bis_collection_utilities.put_line('MV: oki_scm_blg_mv refreshed.') ;
57:
58: bis_collection_utilities.put_line('MV refresh completed successfully.') ;