#table(no partition) 42
alter table D_POSI_AGENCY                move;
alter table D_PROC_AGENCY                move;
alter table D_AGENCY                    move;
alter table D_CENTER                    move;
alter table D_JISA                      move;
alter table F_CONTRACT_SERVICE          move;
alter table F_COUNSEL_DET                move;
alter table F_CYBER_COUNSEL_ACCEPT      move;
alter table F_CYBER_MEMBER              move;
alter table F_SELF_SERVICE_USE          move;
alter table F_CONT_VIEW_SUM              move;
alter table F_STOP_CNCL_MONTH            move;
alter table STG_CUSTOMER_CHANGE_HIST    move;
alter table STG_CONTRACT_SERVICE        move;
alter table STG_CONTRACT                move;
alter table STG_CONTRACT_STATUS_HIST    move;
alter table STG_BILL_ACCOUNT            move;
alter table STG_ADDRESS_HIST            move;
alter table STG_CONTRACT_PROMOTION      move;
alter table STG_BILL_DET                move;
alter table STG_HANDSET_USE_HIST        move;
alter table STG_CONTRACT_BILL_ACCOUNT    move;
alter table STG_CUSTOMER                move;
alter table F_CONTRACT_SUB_PROMOTION    move;
alter table F_CONTRACT_SERVICE_DAILY    move;
alter table F_PPV_PURCHASE              move;
alter table F_CONTRACT_DAILY_S2          move;
alter table F_PPC_CONTRACT              move;
alter table F_SCHE_VIEW_INFO            move;
alter table F_SCHE_VIEW_INFO_S1          move;
alter table F_CHNL_SUM                  move;
alter table F_PRG_SUM                    move;
alter table F_CONT_VIEW_SUM              move;
alter table F_MIN_VIEW_INFO              move;
alter table F_MIN_VIEW_INFO_S1          move;
alter table F_VIEW_INFO                  move;
alter table F_VIEW_INFO_T1              move;
alter table STG_CONTRACT_DISCOUNT        move;
alter table STG_BILL_METHOD_HIST        move;
alter table STG_PAYMENT_RESULT          move;
alter table STG_PAYMENT                  move;
alter table STG_BILL                    move;

**********************************************************************
*********************************************
#index(no partition) 83

alter index D_POSI_AGENCY_PK                rebuild;       
alter index D_PROC_AGENCY_PK                rebuild;
alter index D_AGENCY_PK                    rebuild;
alter index D_CENTER_PK                    rebuild;
alter index D_JISA_PK                      rebuild;
alter index F_CONTRACT_SERVICE_PK          rebuild;
alter index F_COUNSEL_DET_PK                rebuild;
alter index F_COUNSEL_DET_IN01              rebuild;
alter index F_CYBER_MEMBER_PK              rebuild;
alter index F_CYBER_MEMBER_IDX1            rebuild;
alter index F_SELF_SERVICE_USE_PK          rebuild;
alter index F_CONT_VIEW_SUM_IDX03          rebuild;
alter index F_CONT_VIEW_SUM_IDX02          rebuild;
alter index F_CONT_VIEW_SUM_PK              rebuild;
alter index F_CONT_VIEW_SUM_IDX01          rebuild;
alter index F_STOP_CNCL_MONTH_PK            rebuild;
alter index STG_CUSTOMER_CHANGE_HIST_IDX1  rebuild;
alter index STG_CUSTOMER_CHANGE_HIST_IDX2  rebuild;
alter index STG_CONTRACT_SERVICE_IDX1      rebuild;
alter index STG_CONTRACT_IDX1              rebuild;
alter index STG_CONTRACT_IDX2              rebuild;
alter index STG_CONTRACT_IDX3              rebuild;
alter index STG_CONTRACT_IDX4              rebuild;
alter index STG_CONTRACT_IDX5              rebuild;
alter index STG_CONTRACT_STATUS_HIST_IDX1  rebuild;
alter index STG_CONTRACT_STATUS_HIST_IDX2  rebuild;
alter index STG_CONTRACT_STATUS_HIST_IDX3  rebuild;
alter index STG_CONTRACT_STATUS_HIST_IDX4  rebuild;
alter index STG_BILL_ACCOUNT_UQ1            rebuild;
alter index STG_ADDRESS_HIST_IDX1          rebuild;
alter index STG_CONTRACT_PROMOTION_IDX1    rebuild;
alter index STG_CONTRACT_PROMOTION_IDX2    rebuild;
alter index STG_BILL_DET_IDX1              rebuild;
alter index STG_BILL_DET_IDX2              rebuild;
alter index STG_BILL_DET_IDX3              rebuild;
alter index STG_HANDSET_USE_HIST_IDX1      rebuild;
alter index STG_HANDSET_USE_HIST_IDX2      rebuild;
alter index STG_HANDSET_USE_HIST_IDX3      rebuild;
alter index STG_HANDSET_USE_HIST_IDX4      rebuild;
alter index STG_CONTRACT_BILL_ACCOUNT_IDX1  rebuild;
alter index STG_CONTRACT_BILL_ACCOUNT_IDX2  rebuild;
alter index STG_CUSTOMER_IDX1              rebuild;
alter index STG_CUSTOMER_IDX4              rebuild;
alter index F_CONTRACT_SUB_PROMOTION_PK    rebuild;
alter index F_CONTRACT_SERVICE_DAILY_PK    rebuild;
alter index F_PPV_PURCHASE_PK              rebuild;
alter index F_CONTRACT_DAILY_S2_PK          rebuild;
alter index F_PPC_CONTRACT_PK              rebuild;
alter index F_SCHE_VIEW_INFO_IDX05          rebuild;
alter index F_SCHE_VIEW_INFO_PK            rebuild;
alter index F_SCHE_VIEW_INFO_IDX04          rebuild;
alter index SYS_C0032462                    rebuild;
alter index F_CHNL_SUM_PK                  rebuild;
alter index F_PRG_SUM_PK                    rebuild;
alter index F_CONT_VIEW_SUM_IDX03          rebuild;
alter index F_CONT_VIEW_SUM_IDX02          rebuild;
alter index F_CONT_VIEW_SUM_PK              rebuild;
alter index F_CONT_VIEW_SUM_IDX01          rebuild;
alter index F_MIN_VIEW_INFO_IDX03          rebuild;
alter index F_MIN_VIEW_INFO_IDX04          rebuild;
alter index F_MIN_VIEW_INFO_IDX01          rebuild;
alter index F_MIN_VIEW_INFO_IDX02          rebuild;
alter index SYS_C0031822                    rebuild;
alter index F_MIN_VIEW_INFO_S1_IDX01        rebuild;
alter index F_VIEW_INFO_PK                  rebuild;
alter index F_VIEW_INFO_IDX01              rebuild;
alter index F_VIEW_INFO_T1_IDX              rebuild;
alter index STG_CONTRACT_DISCOUNT_IDX1      rebuild;
alter index STG_CONTRACT_DISCOUNT_IDX2      rebuild;
alter index STG_CONTRACT_DISCOUNT_IDX3      rebuild;
alter index STG_BILL_METHOD_HIST_IDX1      rebuild;
alter index STG_PAYMENT_RESULT_IDX1        rebuild;
alter index STG_PAYMENT_RESULT_IDX2        rebuild;
alter index STG_PAYMENT_RESULT_IDX3        rebuild;
alter index STG_PAYMENT_RESULT_IDX4        rebuild;
alter index STG_PAYMENT_RESULT_IDX5        rebuild;
alter index STG_PAYMENT_IDX4                rebuild;
alter index STG_PAYMENT_UQ01                rebuild;
alter index STG_PAYMENT_IDX3                rebuild;
alter index STG_PAYMENT_IDX2                rebuild;
alter index STG_BILL_IDX1                  rebuild;
alter index STG_BILL_IDX2                  rebuild;
alter index STG_BILL_IDX3                  rebuild;

**********************************************************************
******************************************
#table(PARTITION) 5
alter table F_CONTRACT_DAILY_S1  move partition  F_CONTRACT_DAILY_S1_200612;
alter table F_CONTRACT          move partition  F_CONTRACT_200612;
alter table F_BILL              move partition  F_BILL_200612;
alter table F_CONTRACT_EVENT    move partition  F_CONTRACT_EVENT_200612;
alter table F_ONETIME_CHARGE    move partition  F_ONETIME_CHARGE_200612;
                               

**********************************************************************
*********************************************
#index(PARTITION) 8
alter index F_CONTRACT_DAILY_S1_PK  rebuild partition  F_CONTRACT_DAILY_S1_200612;
alter index F_CONTRACT_PK          rebuild partition  F_CONTRACT_200612;
alter index F_CONTRACT_IN01        rebuild partition  F_CONTRACT_200612;
alter index F_CONTRACT_EVENT_IN01  rebuild partition  F_CONTRACT_EVENT_200612;
alter index F_CONTRACT_EVENT_IDX2  rebuild partition  F_CONTRACT_EVENT_200612;
alter index F_CONTRACT_EVENT_PK rebuild;
alter index F_ONETIME_CHARGE_PK rebuild;
alter index F_BILL_PK rebuild;