Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

ORACLE»¹Ô­¶ÎµÄÀàÐÍ

ϵͳ»¹Ô­¶Î
½öΪϵͳ±í¿Õ¼äÖеĶÔÏó±ä»¯ËùÓá£ËüÊÇÔÚÊý¾Ý¿â´´½¨Ê±ÔÚϵͳ±í¿Õ¼äÖд´½¨µÄ¡£ÏµÍ³»¹Ô­¶Î¼È¿ÉÒÔ´æÔÚ²¢¹¤×÷ÔÚ×Ô¶¯Ä£Ê½Ï£¬Ò²¿ÉÒÔ´æÔÚ²¢¹¤×÷ÔÚÊÖ¶¯Ä£Ê½Ï¡£
·Çϵͳ»¹Ô­¶Î
ΪÆäËû±í¿Õ¼äÖжÔÏóµÄ±ä»¯ËùʹÓᣵ±Ò»¸öÊý¾Ý¿â¾ßÓжà¸ö±í¿Õ¼äʱ¾ÍÐèÒªÖÁÉÙÒ»¸öÊÖ¶¯µÄ·Çϵͳ»¹Ô­¶Î»òÒ»¸ö×Ô¶¯¹ÜÀíµÄ»¹Ô­±í¿Õ¼ä¡£
×Ô¶¯Ä£Ê½ ......

OracleµÄORA 00604´íÎó°¸Àýѧϰ

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ÊÕ¹ºSunÈôʧ°Ü IBMÊÇ·ñÔÙÅ×éÏé­Ö¦

¡¶¸£²¼Ë¹¡·ÍøÕ¾½üÈÕ·¢±íÎÄÕ³ƣ¬Èç¹û¼×¹ÇÎÄ74ÒÚÃÀÔªÊÕ¹ºSunµÄ¼Æ»®ÓÉÓÚÅ·Ã˵Ä×èÄÓ¶øÒÔʧ°Ü¸æÖÕ£¬Õâ²¢²»»á¸ø¼×¹ÇÎÄ´øÀ´Ì«´óËðʧ£¬µ«È´»áÁîSunÔâÊÜÖØ´´¡£
¼×¹ÇÎÄÊÕ¹ºSunµÄ½»Ò×ÈÔδ»ñµÃÅ·ÃËίԱ»áµÄÅú×¼¡£
Å·ÃË·´Â¢¶Ï¼à¹Ü²¿Ãŵ£ÐÄ£¬¼×¹ÇÎÄÊÕ¹ºSun½«¶ÔSunµÄ¿ªÔ´Êý¾Ý¿âÒµÎñMySQLÔì³É²»ÀûÓ°Ïì¡£¼×¹ÇÎÄÃæ¶ÔÅ·Ã˵ÄÒÉÂDz¢²»Ô¸×ö³öÈà ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ