job.sql

oracle 全文检索的示例代码. 实现基于分区表的全文检索实现

/***************************************************************************  
*	数据库创建脚本                                                            
*                                                                             
*	重新编码procedure、function
*	增加用户job
*                                                                             
*	auth:jidongzheng                                                          
*	date:2006-4-28 9:19
*	                                                                          
*
****************************************************************************/
/*为各表增加最新的分区。*/
begin
    pro_AutoAddPart();
end;
/
/*****************************************************************************************/
/*

创建并启动job
*/
declare 
	jobno number; 
 	jobcount number; 
BEGIN 
    select count(*) into jobcount from user_jobs where what='pro_dispatch;';
    if jobcount = 0 then 
    	DBMS_JOB.SUBMIT(jobno, 'pro_dispatch;',SYSDATE,'trunc(SYSDATE + 55/(24*60),''Mi'')'); 
    	commit; 
    else
    	--启动job
    	select job into jobno from user_jobs where what='pro_dispatch;';
    	DBMS_JOB.RUN(jobno,TRUE);
    end if;
END;
/

/***********************************************************************************************************/
/*
创建并启动索引同步job
*/

VARIABLE jobno number; 
BEGIN 
    DBMS_JOB.SUBMIT(:jobno,'pro_SyncIndexRecent(''t_http_content'',''idx_p_http_content'');',SYSDATE, 'SYSDATE + (1/24/4)'); 
    commit; 
END; 
/

VARIABLE jobno number; 
BEGIN 
    DBMS_JOB.SUBMIT(:jobno,'pro_SyncIndexRecent(''t_wap_content'',''idx_p_wap_content'');',SYSDATE, 'SYSDATE + (1/24/4)'); 
    commit; 
END; 
/

VARIABLE jobno number; 
BEGIN 
    DBMS_JOB.SUBMIT(:jobno,'pro_SyncIndexRecent(''t_email_content'',''idx_p_email_content'');',SYSDATE, 'SYSDATE + (1/24/4)'); 
    commit; 
END; 
/

VARIABLE jobno number; 
BEGIN 
    DBMS_JOB.SUBMIT(:jobno,'pro_SyncIndexRecent(''t_https_content'',''idx_p_https_content'');',SYSDATE, 'SYSDATE + (1/24/4)'); 
    commit; 
ENd;
/

exit;