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¡£¼ÇµÃµ±Ê±ºÃÏñÈ¥ÂÛ̳ÉÏ·¢Á˸öÌû×ÓÎÊ£¬²»¹ýºÃ¼¸ÌìûÈ˽â´ð£¬ÎÞÄÎÖ®ÏÂÎҾͰÑÌû×Ó¸ø½áÁË¡£
½ñÌìÕýºÃÔÚÒ»±¾ÊéÖп´µ½Óн²Á½ÕßÇø±ðµÄ£¬ÓÖÈ¥ÍøÉÏËÑÁËËÑ£¬Ð¡×ܽáһϣ¬¼ÇÏÂÀ´¡£
±¾µØ¹ÜÀíµÄÁÙʱ±í¿Õ¼äÊÇ»ùÓÚÁÙʱÎļþµÄ£¬ÕâЩÎļþÓëÆÕͨµÄÊý¾ÝÎļþ·Ç³£ÏàËÆ£¬µ«ËüÃÇ»¹¾ßÓÐÈçÏÂÌØÐÔ£º
ÁÙʱ ......
ÒÔǰ·¢¹ýÒ»ÆªÒÆ¶¯Êý¾ÝÎļþµÄ·½·¨µÄÎÄÕ£¬²Î¼û
http://blog.csdn.net/wh62592855/archive/2009/11/20/4843764.aspx
²»¹ýµ±Ê±Ö»¸ø³öÁËÒ»¸öʾÀý¶øÒÑ£¬½ñÌìÔÚÊéÖп´µ½ÁËÁíÒ»ÖÖ·½·¨£¬×ܽáһϣ¬¼ÇÔÚÕâÀï¡£
OracleÌṩÁËÁ½ÌõÒÆ¶¯Êý¾ÝÎļþµÄÓï¾ä
1
ALTER TABLESPACE ±í¿Õ¼äÃû
RENAME DATAFILE 'ÎļþÃû' [,'ÎļþÃû']...
TO ' ......
ORA-00604 error occurred at recursive SQL level string
Cause:An error occurred while processing a recursive SQL statement (a statement applying to internal dictionary tables).
Action:If the situation described in the next error on the stack can be corrected, do so; otherwise contact Oracle Custome ......
´ÓOracle 9iR2 ¿ªÊ¼,ORACLEÌṩÁ˱í/±í¿Õ¼äѹËõ¼¼Êõ,ÒÔ¼õÉÙ´ÅÅÌ¿ªÏú,½ÚÊ¡¿Õ¼ä,²¢ÔÚijЩÇé¿öÏÂÌá¸ß²éѯÐÔÄÜ¡£
±íѹËõÊÇÈçºÎ¹¤×÷µÄ
ÔÚOrcle9iµÚ2°æÖУ¬±íѹËõÌØÐÔͨ¹ýɾ³ýÔÚÊý¾Ý¿â±íÖз¢ÏÖµÄÖØ¸´Êý¾ÝÖµÀ´½ÚÊ¡¿Õ¼ä¡£Ñ¹ËõÊÇÔÚÊý¾Ý¿âµÄÊý¾Ý¿é¼¶±ðÉϽøÐеġ£µ±È·¶¨Ò»¸ö±íÒª±»Ñ¹Ëõºó£¬Êý¾Ý¿â±ãÔÚÿһ¸öÊý¾Ý¿âÊý¾Ý¿éÖб£ ......
Ëæ×Ų»Í¬Ó¦ÓÃÄ£¿é¼äµÄÏûÏ¢½»»¥ºÍͨÐųÉΪһ¸ö¹Ø¼üµÄ¹¦ÄÜ£¬²¢ÇÒ±äµÃÔ½À´Ô½ÖØÒª¡£OracleÒýÈëÁËÒ»ÖÖÇ¿´óµÄ¶ÓÁлúÖÆ£¬Í¨¹ýËü³ÌÐò¼ä¿ÉÒÔʵÏÖÐÅÏ¢µÄ½»»¥£¬oracle°ÑËü³Æ×÷ΪAQ - Advanced Queuing. ʹÓÃOracle AQ£¬ÎÒÃDz»ÐèÒª°²×°¶îÍâµÄÖмä¼þ£¬ËüÊÇOracleÊý¾Ý¿âµÄÒ»¸ö¹¦ÄÜ×é¼þ£¬Ö»ÒªÄã°²×°ÁËOracle Êý¾Ý¿â¾Í¿ÉÒÔʹÓÃAQÁË¡£½ ......