prompt PL/SQL Developer import file
prompt Created on 2007年7月20日 by Administrator
set feedback off
set define off
prompt Disabling triggers for UCR_CRM1.TD_M_TASK...
alter table UCR_CRM1.TD_M_TASK disable all triggers;
prompt Disabling triggers for UCR_CRM1.TD_M_TASK_PLAN...
alter table UCR_CRM1.TD_M_TASK_PLAN disable all triggers;
prompt Loading UCR_CRM1.TD_M_TASK...
insert into UCR_CRM1.TD_M_TASK (TASK_ID, TASK_KIND, TASK_TYPE, PARAMS, CLASS_NAME, USE_TAG, EXPIRED_TAG, SUBSYS_CODE)
values (886, '0', '0', null, 'org.quartz.jobs.NoOpJob', '1', '0', null);
insert into UCR_CRM1.TD_M_TASK (TASK_ID, TASK_KIND, TASK_TYPE, PARAMS, CLASS_NAME, USE_TAG, EXPIRED_TAG, SUBSYS_CODE)
values (1, '0', '0', null, 'org.quartz.jobs.NoOpJob', '1', '0', null);
insert into UCR_CRM1.TD_M_TASK (TASK_ID, TASK_KIND, TASK_TYPE, PARAMS, CLASS_NAME, USE_TAG, EXPIRED_TAG, SUBSYS_CODE)
values (70000001, '0', '0', null, 'com.linkage.sale.bean.invalidation.InvalidScan', '1', '0', null);
commit;
prompt 3 records loaded
prompt Loading UCR_CRM1.TD_M_TASK_PLAN...
insert into UCR_CRM1.TD_M_TASK_PLAN (TASK_ID, PLAN_INDEX, PLAN, PARAMS, USE_TAG, EXPIRED_TAG, LAST_EXEC_TIME, LAST_FINISH_TIME, EXCEPTION_TAG, RESULT_CODE, RESULT_INFO, EXCEPTION_INFO)
values (886, 2, 'W/12:25:00/2007-01-01/1,3,5', 'a=50', '1', '0', to_date('28-05-2007 12:25:00', 'dd-mm-yyyy hh24:mi:ss'), to_date('28-05-2007 12:25:00', 'dd-mm-yyyy hh24:mi:ss'), '0', null, null, null);
insert into UCR_CRM1.TD_M_TASK_PLAN (TASK_ID, PLAN_INDEX, PLAN, PARAMS, USE_TAG, EXPIRED_TAG, LAST_EXEC_TIME, LAST_FINISH_TIME, EXCEPTION_TAG, RESULT_CODE, RESULT_INFO, EXCEPTION_INFO)
values (886, 3, 'O/11:52:00/2007-05-28/2,3', null, '1', '1', to_date('28-05-2007 11:58:00', 'dd-mm-yyyy hh24:mi:ss'), to_date('28-05-2007 11:58:00', 'dd-mm-yyyy hh24:mi:ss'), '0', null, null, null);
insert into UCR_CRM1.TD_M_TASK_PLAN (TASK_ID, PLAN_INDEX, PLAN, PARAMS, USE_TAG, EXPIRED_TAG, LAST_EXEC_TIME, LAST_FINISH_TIME, EXCEPTION_TAG, RESULT_CODE, RESULT_INFO, EXCEPTION_INFO)
values (886, 1, 'D/10:30:00/2007-01-01', null, '1', '0', to_date('29-05-2007 10:30:00', 'dd-mm-yyyy hh24:mi:ss'), to_date('29-05-2007 10:30:00', 'dd-mm-yyyy hh24:mi:ss'), '0', null, null, null);
insert into UCR_CRM1.TD_M_TASK_PLAN (TASK_ID, PLAN_INDEX, PLAN, PARAMS, USE_TAG, EXPIRED_TAG, LAST_EXEC_TIME, LAST_FINISH_TIME, EXCEPTION_TAG, RESULT_CODE, RESULT_INFO, EXCEPTION_INFO)
values (886, 52, 'D/12:30:00/2007-01-01', null, '1', '0', to_date('28-06-2007 12:30:00', 'dd-mm-yyyy hh24:mi:ss'), to_date('28-06-2007 12:30:00', 'dd-mm-yyyy hh24:mi:ss'), '0', null, null, null);
insert into UCR_CRM1.TD_M_TASK_PLAN (TASK_ID, PLAN_INDEX, PLAN, PARAMS, USE_TAG, EXPIRED_TAG, LAST_EXEC_TIME, LAST_FINISH_TIME, EXCEPTION_TAG, RESULT_CODE, RESULT_INFO, EXCEPTION_INFO)
values (1, 1, 'D/10:30:00/2007-01-01', null, '1', '0', to_date('29-05-2007 10:30:00', 'dd-mm-yyyy hh24:mi:ss'), to_date('29-05-2007 10:30:00', 'dd-mm-yyyy hh24:mi:ss'), '0', null, null, null);
insert into UCR_CRM1.TD_M_TASK_PLAN (TASK_ID, PLAN_INDEX, PLAN, PARAMS, USE_TAG, EXPIRED_TAG, LAST_EXEC_TIME, LAST_FINISH_TIME, EXCEPTION_TAG, RESULT_CODE, RESULT_INFO, EXCEPTION_INFO)
values (70000001, 1, 'D/18:23:00/2007-07-13', 'tableName=TF_SM_TASK;endTimeField=DEMAND_END_TIME;validField=VALID_FLAG;invalidTag=0', '1', '0', to_date('13-07-2007 18:23:00', 'dd-mm-yyyy hh24:mi:ss'), to_date('13-07-2007 18:23:00', 'dd-mm-yyyy hh24:mi:ss'), '0', '200707', '失效扫描成功', null);
commit;
prompt 6 records loaded
prompt Enabling triggers for UCR_CRM1.TD_M_TASK...
alter table UCR_CRM1.TD_M_TASK enable all triggers;
prompt Enabling triggers for UCR_CRM1.TD_M_TASK_PLAN...
alter table UCR_CRM1.TD_M_TASK_PLAN enable all triggers;
set feedback on
set define on
prompt Done.
