441: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_lead_weekly_facts nologging ';
442:
443: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_lead_daily_facts_s CACHE 1000 ';
444:
445: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_lead_weekly_facts_s CACHE 1000 ';
446:
447: /* Dropping INdexes */
448: BIM_UTL_PKG.DROP_INDEX('BIM_R_LEAD_DAILY_FACTS');
449: BIM_UTL_PKG.DROP_INDEX('BIM_R_LEAD_WEEKLY_FACTS');
866:
867: /*BEGIN BLOCK FOR THE WEEKLY INSERT */
868:
869: l_table_name := 'bim_r_lead_weekly_facts';
870: l_seq_name := 'bim_r_lead_weekly_facts_s';
871:
872: INSERT /*+ append parallel(LWF,1) */
873: INTO bim_r_lead_weekly_facts LWF
874: (
904: ,quotes_open
905: ,orders
906: )
907: SELECT /*+ parallel(INNER,1) */
908: bim_r_lead_weekly_facts_s.nextval
909: ,sysdate
910: ,sysdate
911: ,l_user_id
912: ,l_user_id
1004: BIM_UTL_PKG.CREATE_INDEX('BIM_R_LEAD_WEEKLY_FACTS');
1005:
1006:
1007:
1008: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_lead_weekly_facts_s CACHE 20';
1009:
1010:
1011:
1012: EXCEPTION