cse p36 rebuild scripts

7/25/2019 Cse p36 Rebuild Scripts

1/10

*. willow. ITEM_EQUIPMENT_PRICES rebuild;

alter table willow. ITEM_OPTION_PRICES rebuild;

alter table willow. ITEM_PRICE_DETAILS rebuild;

alter table willow. A_S_INT!_IN_STA"IN"_TA#LE_ rebuild;

alter table willow. RESIDUAL_PERIODS rebuild;

alter table willow. E$TERNAL_ACCOUNTS rebuild;

alter table willow. MUL_QUOTE_%AR rebuild;

alter table willow. QUOTATION_MODEL_!INANCES rebuild;

alter table willow. "E_RATE_ELEMENTS rebuild;

alter table willow. LDE%AL_LINES rebuild;

alter table willow. MAINTENANCE_TA#LES rebuild;

alter table willow. QUOTE_E$CESS_MILEA"E_C&AR"ES rebuild;

alter table willow. CDE%AL rebuild;

alter table willow. QUOTE_STATUS_LO" rebuild;

alter table willow. S_'O#_ERRORS_&IST rebuild;

alter table willow. #M_MAINT_MODELS rebuild;

alter table willow. AUD_INT!_IN_CONTACT_ADDRESS_ rebuild;

alter table willow. AUD_INT!_IN_E$TERNAL_ACCOUNT_ rebuild;alter table willow. AUD_INT!_IN_E$T_ACC_ADDRESS_ rebuild;

alter table willow. A_INT!_IN_ADDITIONALDATA_ rebuild;

alter table willow. A_INT!_IN_ASSET_(E)S_ rebuild;

alter table willow. A_INT!_IN_!LEETMASTERS_ rebuild;

alter table willow. OPTION_PRICE_LISTS rebuild;

alter table willow. A_INT!_IN_%E&ICLE_E$TRAS_ rebuild;

alter table willow. INT!_OUT_SLS_QTTN_%E&_E$TR_P rebuild;


2/10

ALTERINDE$++ONER++.++INDE$_NAME++RE#UILD;

alter i,de- ILLO(.QEMC_#N_!(_I rebuild;

alter i,de- ILLO(.QEMC_QMD_!(_I rebuild;

alter i,de- ILLO(.QEMC_P( rebuild;

alter i,de- ILLO(.QM!_U( rebuild;

alter i,de- ILLO(.QM!_P( rebuild;

alter i,de- ILLO(.OPL_P( rebuild;

alter i,de- ILLO(.ID$_OPL_DATE rebuild;

alter i,de- ILLO(.MQ%_U( rebuild;

alter i,de- ILLO(.MQ%_MDL_!(_I rebuild;

alter i,de- ILLO(.MQ%_P( rebuild;

alter i,de- ILLO(.MT#_MT#_!(_I rebuild;

alter i,de- ILLO(.MT#_#MMM_!(_I rebuild;

alter i,de- ILLO(.MT#_M#M_!(_I rebuild;

alter i,de- ILLO(.MT#_DAC_!(_I rebuild;

alter i,de- ILLO(.MT#_OAC_!(_I rebuild;

alter i,de- ILLO(.MT#_P( rebuild;

alter i,de- ILLO(.MT#_MDL_!(_I rebuild;alter i,de- ILLO(.IEP_IETCO_!(_I rebuild;

alter i,de- ILLO(.IEP_IP&_!(_I rebuild;

alter i,de- ILLO(.IEP_IEC_!(_I rebuild;

alter i,de- ILLO(.IEP_P( rebuild;

alter i,de- ILLO(.IOP_IP&_IOC_I rebuild;

alter i,de- ILLO(.IOP_IP&_!(_I rebuild;

alter i,de- ILLO(.IOP_ITOC_!(_I rebuild;

alter i,de- ILLO(.IOP_IPC_!(_I rebuild;

alter i,de- ILLO(.IOP_P( rebuild;

alter i,de- ILLO(.IPD_/_I rebuild;

alter i,de- ILLO(.IPD_A"#_!(_I rebuild;

alter i,de- ILLO(.IPD_IP&_!(_I rebuild;alter i,de- ILLO(.IPD_OD#_!(_I rebuild;

alter i,de- ILLO(.IPD_P( rebuild;

alter i,de- ILLO(.LDE%AL_LINES_ID$ rebuild;

alter i,de- ILLO(.LDE%AL_LINES_P( rebuild;

alter i,de- ILLO(."E_ID$_0/ rebuild;

alter i,de- ILLO(.EA_EA_!(1_I rebuild;


alter i,de- ILLO(.EA_CU_!(_I rebuild;

alter i,de- ILLO(.EA_ID$_03 rebuild;

alter i,de- ILLO(.EA_P( rebuild;

alter i,de- ILLO(.EA_ID$_0/ rebuild;


alter i,de- ILLO(.EA_EA_!(_I rebuild;

alter i,de- ILLO(.EA_CRT_!(_I rebuild;

alter i,de- ILLO(.EA_EA_!(/_I rebuild;

alter i,de- ILLO(.EA_EA_!(_I rebuild;




alter i,de- ILLO(.EA_ID$_0 rebuild;

alter i,de- ILLO(.CDE%AL_P( rebuild;

alter i,de- ILLO(.CDE%AL_ID$ rebuild;

alter i,de- ILLO(.#MMM_MR"_!(_I rebuild;alter i,de- ILLO(.#MMM_MDL_!(_I rebuild;


3/10

alter i,de- ILLO(.#MMM_DAC_!(_I rebuild;

alter i,de- ILLO(.#MMM_M#M_!(_I rebuild;

alter i,de- ILLO(.#MMM_OAC_!(_I rebuild;

alter i,de- ILLO(.#MMM_P( rebuild;

alter i,de- ILLO(.RPR_P( rebuild;

alter i,de- ILLO(.RPR_RT#_!(_I rebuild;

alter i,de- ILLO(.QSL_QMD_!(_I rebuild;

alter i,de- ILLO(.QSL_QUO_!(_I rebuild;

alter i,de- INTER!ACE.QSL_P( rebuild;

alter i,de- INTER!ACE.QSL_P&$_!LT_ID$ rebuild;

alter i,de- INTER!ACE.'ER_P(_& rebuild;

alter i,de- INTER!ACE.'ER_ERR_!(_I_& rebuild;

alter i,de- INTER!ACE.'ER_IN&_!(_I_& rebuild;

alter i,de- INTER!ACE.'ER_'E%_!(_I_& rebuild;


4/10

alter table MUL_QUOTE_ELE rebuild;

alter table MUL_QUOTE_OPT rebuild;

alter table QUOTATION_MODEL_DISCOUNTS rebuild;

alter table CDE%AL_LINES rebuild;

alter table QUOTATION_MODELS rebuild;

alter table RESIDUAL_%ALUES rebuild;


5/10

alter i,de- ILLO(.R%A_ID$_0/ rebuild;

alter i,de- ILLO(.R%A_DTN_!(_I rebuild;

alter i,de- ILLO(.R%A_P( rebuild;

alter i,de- ILLO(.QMD_RU_I rebuild;

alter i,de- ILLO(.QMD_RT#_!(_I rebuild;

alter i,de- ILLO(.QMD_QMD_!(_I rebuild;

alter i,de- ILLO(.QMD_LCD_!(_I rebuild;

alter i,de- ILLO(.QMD_!MS_!(_I rebuild;

alter i,de- ILLO(.QMD_MDL_!(_I rebuild;

alter i,de- ILLO(.QMD_!MS_!(_I rebuild;

alter i,de- ILLO(.QMD_QSTC_!(_I rebuild;

alter i,de- ILLO(.QMD_QUO_!(_I rebuild;

alter i,de- ILLO(.QMD_MR"_!(_I rebuild;

alter i,de- ILLO(.QMD_&PD_!(_I rebuild;

alter i,de- ILLO(.QMD_UOM_!(_I rebuild;

alter i,de- ILLO(.QMD_MT#_!(_I rebuild;

alter i,de- ILLO(.QMD_&P_!(_I rebuild;

alter i,de- ILLO(.QMD_CLN_!(_I rebuild;alter i,de- ILLO(.QMD_P&_!(_I rebuild;

alter i,de- ILLO(.QMD_INS_!(_I rebuild;

alter i,de- ILLO(.QMD_CSC/_!(_I rebuild;

alter i,de- ILLO(.QMD_SUP_!(_I rebuild;

alter i,de- ILLO(.QMD_MDL_!(_I rebuild;

alter i,de- ILLO(.QMD_CC"C_!(_I rebuild;

alter i,de- ILLO(.QMD_P( rebuild;

alter i,de- ILLO(.QMD_U(/ rebuild;

alter i,de- ILLO(.QMD_QMD_!(_I rebuild;

alter i,de- ILLO(.QMDD_QMD_!(_I rebuild;

alter i,de- ILLO(.QMDD_%R#_T)PE_I rebuild;

alter i,de- ILLO(.QMDD_EA_!(/ rebuild;alter i,de- ILLO(.S)S_C00603 rebuild;

alter i,de- ILLO(.MQE_QUO_!(_I rebuild;

alter i,de- ILLO(.MQE_ID$_/ rebuild;

alter i,de- ILLO(.MQE_P( rebuild;

alter i,de- ILLO(.MQO_MQE_!(_I rebuild;

alter i,de- ILLO(.MQO_P( rebuild;

alter i,de- ILLO(.CDE%AL_LINES_ID$ rebuild;

alter i,de- ILLO(.CDE%AL_LINES_P( rebuild;


6/10

ALTER TA#LE QUOTATION_NON_ELEMENTS RE#UILD;

ALTER TA#LE QUOTATION_ELEMENTS RE#UILD;

ALTER TABLE QUOTE_ELEMENT_PARAMETERS REBUILD;

ALTER TABLE VEH_SELECTIONS REBUILD;


7/10

SUM7#)TES89/059/059/05 SE"MENT_T)PE SE"MENT_NAME TA#LESPACE_NAME

56.36:326 INDE$ %E&S_P( LAR"E_ID$

31.436:326 INDE$ %E&S_ID$_0/ LAR"E_ID$

3/.//:344 INDE$ QEP_U( LAR"E_ID$

2.04:45326 INDE$ QEP_P( LAR"E_ID$

/2.3//635326 INDE$ QEP_QEL_!(_I LAR"E_ID$

:.1/:/5016 INDE$ QEP_QEL_!(_I LAR"E_ID$

3.:3/15016 INDE$ QNEL_QMD_!(_I LAR"E_ID$

3.:/2:1426 INDE$ QEL_QMD_!(_I LAR"E_ID$

3.16 INDE$ R%A_DTN_!(_I LAR"E_ID$

3.5326 INDE$ QEL_P( LAR"E_ID$

3.5021616 INDE$ QNEL_P( LAR"E_ID$

3.6 INDE$ R%A_ID$_0/ LAR"E_ID$

3.0:521616 INDE$ QNEL_LEL_!(_I LAR"E_ID$

.254051426 INDE$ MQO_MQE_!(_I LAR"E_ID$

.20203/6 INDE$ MQO_P( LAR"E_ID$

.1426 INDE$ R%A_P( LAR"E_ID$

.16 INDE$ QEL_LEL_!(_I LAR"E_ID$/./426 INDE$ QEMC_QMD_!(_I LAR"E_ID$

/.0115016 INDE$ S)S_C00603 LAR"E_ID$

/.016 INDE$ QMDD_EA_!(/ LAR"E_ID$

0.:/426 INDE$ QEMC_P( LAR"E_ID$

0.4/5563/6 INDE$ QMDD_QMD_!(_I LAR"E_ID$

0.25:035326 INDE$ QMD_U(/ LAR"E_ID$

0.13046:326 INDE$ QMDD_%R#_T)PE_I LAR"E_ID$

0.11:63/6 INDE$ MQE_QUO_!(_I LAR"E_ID$

0.624/6 INDE$ QEMC_#N_!(_I LAR"E_ID$

0.616 INDE$ MQE_ID$_/ LAR"E_ID$

0.631616 INDE$ MQE_P( LAR"E_ID$

0.630235326 INDE$ QSL_QUO_!(_I LAR"E_ID$0.6::1426 INDE$ QSL_QMD_!(_I LAR"E_ID$

0.6/2624/6 INDE$ QMD_QUO_!(_I LAR"E_ID$

0.6/616 INDE$ QMD_MT#_!(_I LAR"E_ID$

0.564:45326 INDE$ MQ%_U( LAR"E_ID$

0.53/15016 INDE$ QSL_P( LAR"E_ID$

0.3:45326 INDE$ QMD_RT#_!(_I LAR"E_ID$

0.312/426 INDE$ QMD_RU_I LAR"E_ID$

0.3615563/6 INDE$ QMD_UOM_!(_I LAR"E_ID$

0.3663:016 INDE$ QM!_U( LAR"E_ID$

0.35326 INDE$ IPD_/_I LAR"E_ID$

0.3324:016 INDE$ QMD_MDL_!(_I LAR"E_ID$

0.330024/6 INDE$ QMD_LCD_!(_I LAR"E_ID$

0.34/6 INDE$ QMD_MR"_!(_I LAR"E_ID$

0.303/6 INDE$ QMD_QSTC_!(_I LAR"E_ID$

0.3/5563/6 INDE$ MQ%_MDL_!(_I LAR"E_ID$

0.30115016 INDE$ QMD_P&_!(_I LAR"E_ID$

0.4:016 INDE$ QMD_P( LAR"E_ID$

0.6 INDE$ IPD_IP&_!(_I LAR"E_ID$

0.510:326 INDE$ CDE%AL_LINES_ID$ LAR"E_ID$

0.55/5016 INDE$ IPD_P( LAR"E_ID$

0.35326 INDE$ IOP_ITOC_!(_I LAR"E_ID$

0.35326 INDE$ IPD_OD#_!(_I LAR"E_ID$

0.35326 INDE$ IOP_IP&_!(_I LAR"E_ID$0./0:326 INDE$ MQ%_P( LAR"E_ID$


8/10

0.03/6 INDE$ IOP_P( LAR"E_ID$

0.03/6 INDE$ IPD_A"#_!(_I LAR"E_ID$

0./2:1426 INDE$ IOP_IPC_!(_I LAR"E_ID$

0./5016 INDE$ IEP_IP&_!(_I LAR"E_ID$

0./5016 INDE$ IEP_IEC_!(_I LAR"E_ID$

0./34/6 INDE$ "E_ID$_0/ LAR"E_ID$

0./34/6 INDE$ CDE%AL_LINES_P( LAR"E_ID$

0./34/6 INDE$ ID$_OPL_DATE LAR"E_ID$

0./34/6 INDE$ IEP_P( LAR"E_ID$

0./0:326 INDE$ IEP_IETCO_!(_I LAR"E_ID$

0./0/616 INDE$ #MMM_MDL_!(_I LAR"E_ID$

0./0/616 INDE$ MT#_MDL_!(_I LAR"E_ID$

0.0:326 INDE$ MT#_P( LAR"E_ID$

0.0:326 INDE$ #MMM_MR"_!(_I LAR"E_ID$

0.0:2235326 INDE$ #MMM_P( LAR"E_ID$

0.016 INDE$ LDE%AL_LINES_P( LAR"E_ID$

0.016 INDE$ CDER%N_ID$ LAR"E_ID$

0.016 INDE$ 'ER_P(_& LAR"E_ID$


9/10

alter i,de- ILLO(.QEP_P( rebuild;

alter i,de- ILLO(.QEP_QEL_!(_I rebuild;

alter i,de- ILLO(.QEP_QEL_!(_I rebuild;

alter i,de- ILLO(.QEP_U( rebuild;

alter i,de- ILLO(.QNEL_P( rebuild;

alter i,de- ILLO(.QNEL_LEL_!(_I rebuild;

alter i,de- ILLO(.QNEL_QDA_!(_I rebuild;

alter i,de- ILLO(.QNEL_QMA_!(_I rebuild;

alter i,de- ILLO(.QNEL_QMD_!(_I rebuild;

alter i,de- ILLO(.QEL_LEL_!(_I rebuild;

alter i,de- ILLO(.QEL_QMD_!(_I rebuild;

alter i,de- ILLO(.QEL_QMA_!(_I rebuild;

alter i,de- ILLO(.QEL_QDA_!(_I rebuild;

alter i,de- ILLO(.QEL_P( rebuild;

alter i,de- ILLO(.%E&S_ID$_0/ rebuild;

alter i,de- ILLO(.%E&S_P( rebuild;


10/10

SUM7#)TES89/059/059/05 SE"MENT_T)PE SE"MENT_NAME TA#LESPACE_NAME

56.36:326 INDE$ %E&S_P( LAR"E_ID$

31.436:326 INDE$ %E&S_ID$_0/ LAR"E_ID$

3/.//:344 INDE$ QEP_U( LAR"E_ID$

2.04:45326 INDE$ QEP_P( LAR"E_ID$

/2.3//635326 INDE$ QEP_QEL_!(_I LAR"E_ID$

:.1/:/5016 INDE$ QEP_QEL_!(_I LAR"E_ID$

3.:3/15016 INDE$ QNEL_QMD_!(_I LAR"E_ID$

3.:/2:1426 INDE$ QEL_QMD_!(_I LAR"E_ID$

3.16 INDE$ R%A_DTN_!(_I LAR"E_ID$

3.5326 INDE$ QEL_P( LAR"E_ID$

3.5021616 INDE$ QNEL_P( LAR"E_ID$

3.6 INDE$ R%A_ID$_0/ LAR"E_ID$

3.0:521616 INDE$ QNEL_LEL_!(_I LAR"E_ID$

.254051426 INDE$ MQO_MQE_!(_I LAR"E_ID$

.20203/6 INDE$ MQO_P( LAR"E_ID$

.1426 INDE$ R%A_P( LAR"E_ID$.16 INDE$ QEL_LEL_!(_I LAR"E_ID$

/./426 INDE$ QEMC_QMD_!(_I LAR"E_ID$

/.0115016 INDE$ S)S_C00603 LAR"E_ID$

/.016 INDE$ QMDD_EA_!(/ LAR"E_ID$

0.:/426 INDE$ QEMC_P( LAR"E_ID$

cse p36 rebuild scripts

Documents