oracleÈ«ÎÄË÷ÒýºÍ¶¨Ê±ÈÎÎñ
--Ê×Ïȼì²éÊý¾Ý¿âÖÐÊÇ·ñÓÐCTXSYSÓû§ºÍCTXAPP½ÅÉ«¡£
--Èç¹ûûÓÐÕâ¸öÓû§ºÍ½ÇÉ«£¬Òâζ×ÅÄãµÄÊý¾Ý¿â´´½¨Ê±Î´°²×°intermedia¹¦ÄÜ¡£
--Äã±ØÐëÐÞ¸ÄÊý¾Ý¿âÒÔ°²×°ÕâÏÄÜ¡£
--ÓÃsysÓû§ÎªÁËÓû§gzinfo·ÖÅäȨÏÞ
grant
CTXAPP
to
gzinfo;
grant
execute
on
ctx_ddl
to
gzinfo;
--»Øµ½gzinfoÓû§
--´´½¨²âÊÔ±í,CLOBTEXT×Ö¶ÎΪÐèÒªË÷ÒýµÄ×Ö¶Î
create
table
INXTEXT (ID
number
(
13
), CLOBTEXT CLOB);
--´´½¨·Ö´Ê,ÕâÀïÓÃÁËchinese_vgram_lexer,·Ö´ÊÃûΪGZINFO_LEXER
call ctx_ddl.create_preference (
'
GZINFO_LEXER
'
,
'
chinese_vgram_lexer
'
);
--´´½¨Ë÷Òý,Ë÷ÒýÃûΪINX_TEST (PARAMETERS ÖÐÐèÒªÒÔLEXER¿ªÍ·,Ìæ»»Ê±ÓÃreplace)
create
index
INX_TEST
ON
INXTEXT (CLOBTEXT) INDEXTYPE
IS
CTXSYS.CONTEXT PARAMETERS (
'
LEXER INFO_LEXER
'
);
--´´½¨¼Ç¼±í
create
table
JOBTEST (ID DATE, CONTENT
VARCHAR2
(
200
));
--´´½¨Í¬²½´æ´¢¹ý³Ì,ctx_ddl.sync_index('INX_TEST')Ϊͬ²½È«ÎÄË÷Òý,ͬ²½±í×Ö¶ÎÖеÄÐÅÏ¢
create
or
replace
procedure
PROC_SYNC_INDEX
is
begin
ctx_ddl.sync_index(
'
INX_TEST
'
);
insert
into
JOBTEST
values
(SYSDATE,
'
ͬ²½ÈÎÎñÓÚ
'
||
SYSDATE
||
'
Ö´ÐÐ
'
);
end
;
--´´½¨Í¬²½ÓÅ»¯´æ´¢¹ý³Ì,ctx_ddl.optimize_index('INX_TEST','FULL')ΪÓÅ»¯È«ÎÄË÷Òý
Code
create
or
replace
procedure
PROC_SYNC_OPTIMIZE
is
begin
ctx_ddl.sync_index(
'
INX_TEST
'
);
ctx_ddl.optimize_index(
'
INX_TEST
'
,
'
FULL
'
);
insert
into
JOBTEST
values
(SYSDATE,
'
ͬ²½ÓÅ»¯ÈÎÎñÓÚ
'
||
SYSDATE
||
'
Ö´ÐÐ
'
);
end
;
--´´½¨¶¨Ê±ÈÎÎñÒÔ±ãͬ²½È«ÎÄË÷Òý
DECLARE
X
NUMBER
;
BEGIN
SYS.DBMS_JOB.SUBMIT
(
job &n
Ïà¹ØÎĵµ£º
Õâ¸öÎÊÌâÒÔǰÀ§ÈŹýÎÒ£¬Á½Õߺó׺Ãû¶¼ÊÇ.DBF¡£¼ÇµÃµ±Ê±ºÃÏñÈ¥ÂÛ̳ÉÏ·¢Á˸öÌû×ÓÎÊ£¬²»¹ýºÃ¼¸ÌìûÈ˽â´ð£¬ÎÞÄÎÖ®ÏÂÎҾͰÑÌû×Ó¸ø½áÁË¡£
½ñÌìÕýºÃÔÚÒ»±¾ÊéÖп´µ½Óн²Á½ÕßÇø±ðµÄ£¬ÓÖÈ¥ÍøÉÏËÑÁËËÑ£¬Ð¡×ܽáһϣ¬¼ÇÏÂÀ´¡£
±¾µØ¹ÜÀíµÄÁÙʱ±í¿Õ¼äÊÇ»ùÓÚÁÙʱÎļþµÄ£¬ÕâЩÎļþÓëÆÕͨµÄÊý¾ÝÎļþ·Ç³£ÏàËÆ£¬µ«ËüÃÇ»¹¾ßÓÐÈçÏÂÌØÐÔ£º
ÁÙʱ ......
ϵͳ»¹Ô¶Î
½öΪϵͳ±í¿Õ¼äÖеĶÔÏó±ä»¯ËùÓá£ËüÊÇÔÚÊý¾Ý¿â´´½¨Ê±ÔÚϵͳ±í¿Õ¼äÖд´½¨µÄ¡£ÏµÍ³»¹Ô¶Î¼È¿ÉÒÔ´æÔÚ²¢¹¤×÷ÔÚ×Ô¶¯Ä£Ê½Ï£¬Ò²¿ÉÒÔ´æÔÚ²¢¹¤×÷ÔÚÊÖ¶¯Ä£Ê½Ï¡£
·Çϵͳ»¹Ô¶Î
ΪÆäËû±í¿Õ¼äÖжÔÏóµÄ±ä»¯ËùʹÓᣵ±Ò»¸öÊý¾Ý¿â¾ßÓжà¸ö±í¿Õ¼äʱ¾ÍÐèÒªÖÁÉÙÒ»¸öÊÖ¶¯µÄ·Çϵͳ»¹Ô¶Î»òÒ»¸ö×Ô¶¯¹ÜÀíµÄ»¹Ô±í¿Õ¼ä¡£
×Ô¶¯Ä£Ê½ ......
ÉÏÆª½éÉÜÁ˾²Ä¬°²×°Êý¾Ý¿âÈí¼þ£¬ÏÂÃæ½éÉܾ²Ä¬´´½¨Êý¾Ý¿âµÄ·½·¨¡£
1. ÓÃDBCA¸ù¾ÝÖÖ×ÓÊý¾Ý¿â´´½¨Ò»¸öÄ£°å
£¨ÖÖ×ÓÊý¾Ý¿â¾ÍÊÇÔ´Êý¾Ý¿â£¬Èç¹ûûÓÐÔ´Êý¾Ý¿â£¬¿ÉÒÔÓÃDBCA´´½¨Ò»¸öеÄÄ£°æ»ò±à¼ÔÓеÄÄ£°æ£©
2. ½«Oracle DB°²×°ÅÌÀïÃæresponseĿ¼ÏµÄdbca.rsp¿½±´µ½±¾»úÉÏ
3. ÐÞ¸Ädbca.rspÎļþ£¬½«Ä£°åÃûºÍDBÃûÌí¼Ó½øÈ¥
GDB ......
http://www.haoxiai.net/shujuku/Oracle/111145.html
Ò»¡¢Êý¾Ý¿âÃû
ʲôÊÇÊý¾Ý¿âÃû
Êý¾Ý¿âÃû¾ÍÊÇÒ»¸öÊý¾Ý¿âµÄ±êʶ£¬¾ÍÏñÈ˵ÄÉí·ÝÖ¤ºÅÒ»Ñù¡£ËûÓòÎÊýDB_NAME±íʾ£¬Èç¹ûһ̨»úÆ÷ÉÏ×°Á˶àÈ«Êý¾Ý¿â£¬ÄÇôÿһ¸öÊý¾Ý¿â¶¼ÓÐÒ»¸öÊý¾Ý¿âÃû¡£ÔÚÊý¾Ý¿â°²×°»ò´´½¨Íê³ÉÖ®ºó£¬²ÎÊýDB_NAME±»Ð´Èë²ÎÊýÎļþÖ®ÖС£¸ñʽÈçÏ£º
DB_NAME=m ......
Ëæ×Ų»Í¬Ó¦ÓÃÄ£¿é¼äµÄÏûÏ¢½»»¥ºÍͨÐųÉΪһ¸ö¹Ø¼üµÄ¹¦ÄÜ£¬²¢ÇÒ±äµÃÔ½À´Ô½ÖØÒª¡£OracleÒýÈëÁËÒ»ÖÖÇ¿´óµÄ¶ÓÁлúÖÆ£¬Í¨¹ýËü³ÌÐò¼ä¿ÉÒÔʵÏÖÐÅÏ¢µÄ½»»¥£¬oracle°ÑËü³Æ×÷ΪAQ - Advanced Queuing. ʹÓÃOracle AQ£¬ÎÒÃDz»ÐèÒª°²×°¶îÍâµÄÖмä¼þ£¬ËüÊÇOracleÊý¾Ý¿âµÄÒ»¸ö¹¦ÄÜ×é¼þ£¬Ö»ÒªÄã°²×°ÁËOracle Êý¾Ý¿â¾Í¿ÉÒÔʹÓÃAQÁË¡£½ ......