261: -- dbms_output.put_line('Schemas are:'||l_applsys_schema);
262:
263: --- first check if paritions for old plans in summary table exist or not. If not then
264: -- create them
265: MSC_POST_PRO.CREATE_PARTITIONS(l_err_buf, l_ret_code);
266: IF (l_ret_code <> 0) THEN
267: --- error occured during partition creation in summary tables
268: --- Since partitions are not created for lower plan IDs successfully, partition
269: --- for higher plan ID will not be created
421: --dbms_output.put_line('Schemas are:'||l_applsys_schema);
422:
423: --- first check if paritions for old plans in summary table exist or not. If not then
424: -- create them
425: MSC_POST_PRO.CREATE_PARTITIONS(l_err_buf, l_ret_code);
426: IF (l_ret_code <> 0) THEN
427: --- error occured during partition creation in summary tables
428: --- Since partitions are not created for lower instance IDs successfully, partition
429: --- for higher instnaces will not be created