Oracle TextÔâÓöÕ½[2009 12 31 16:15]
ÊÖÍ·ÕýÔÚ½øÐÐÒ»¸öÏîÄ¿£¬ÐèҪȫÎļìË÷£¬¾¹ýͬÊÂ×ÐϸËÑË÷·¢ÏÖ£ºoracleÌṩoracle textµÄÈ«ÎļìË÷¹¦ÄÜ¡£
oracle textµÄ¼òµ¥Ó¦ÓþͬʲâÊÔ½á¹ûÕý³££¬°´ÕÕÏîÄ¿ÒªÇó(ÏîÄ¿Ô¤¶¨·½°¸wordÎĵµ´æÈëÊý¾Ý¿â(blobÀàÐÍ))ʹÓÃoracle text²éѯ½á¹ûÈ·ÊÇΪ¿Õ£¬Í¬ÊÂÑо¿µ½´ËÖжϡ£
BOSS¼ûÎÒ¶ÔoracleÐËȤŨºñ£¬ÈÃÎÒ½ÓÊÖ£¬ÓÚÊÇÎÒÁÙʱ±§·ð½Å¿ªÊ¼Ñ§Ï°oracle text£¬×ÁÄ¥³öһЩ´ó¸ÅÍ·Ð÷£¬²½ÖèÈçÏ£º1)ÊÚȨctxsys½ÇÉ«£»2)½¨±í£»3)ÉèÖÃË÷Òý²ÎÊý¡¢´´½¨Ë÷Òý£»4)²éѯ¡£Í·Ð÷¹éÍ·Ð÷£¬µ«ÊÇ¿¨×¡Í¬ÊµÄÎÊÌâͬÑù¿¨×¡ÎÒ£¬ÎÒ¿ªÊ¼»³ÒÉstringÐÍÎÞ·¨ÓëblobÐÍÆ¥Åä²éѯ£¬ºóÓÖ·¢ÏÖÐí¶àÈ˶¼ÊÇÖ±½Ó½«×Ö·û´®²åÈëblobÐÍÁУ¬ÖÁ´ËÏÝÈëÃÔ㣬×îÖÕ¾ö¶¨ÔÚCSDN·¢ÌûÇóÖú£¬¾Ò»Î»ÈÈÐÄÈË(Ôڴ˸ÐлCSDNµÄDenonly )ÌáʾwordÎĵµ×ª»¯Îª¶þ½øÖƺóµÃµ½µÄ¿ÉÄܲ»È«ÊÇÎı¾ÄÚÈÝ£¬ÖÕ´óÎò£¡
ºóÈÃͬÊ°ÑÒ»¸öTXTÎı¾×ª»¯ºó´æÈëÊý¾Ý¿â£¬Ê¹ÓÃÀÏ·½·¨²éѯ£¬²éѯ½á¹ûÕýÈ·£¡´óϲ£¡²éѯ¹ý³Ì¿ÉÐУ¬ÎÊÌâ¿Ï¶¨ÔÚblob£¡
²»¹ý;ÖÐÓÖ×ßÁËһЩÍä·£¬oracleÖд洢ÍⲿOSÎļþ·¾¶£¬oracle textÖ±½Ó¶ÔÕâЩÎļþ¼ìË÷£¬¿ÉϧûÄÜÖ¤Ã÷¿ÉÐл¹ÊDz»¿ÉÐУ¬ÁôÏÂÒ»¸öÐüÄî¡£
¾¹ý°Ù¶ÈµÄÂÒÆß°ËÔãËÑË÷·¢ÏÖÒ»¸öÌû×Ó£¬ÉÏÃæ²ûÊöÁËÔÚ´´½¨Ë÷ÒýÇ°É趨²»Í¬filetrÑ¡ÏîµÄЧ¹û£¬ÆäÖÐCTXSYS.INSO_FILTER¿ÉÒÔ¶ÔһЩ¶þ½øÖÆÎļþµÄÎı¾²¿·ÖºÍ·ÇÎı¾²¿·Ö¹ýÂË·ÖÀ룬°Ù¶ÈµÃµ½Ò»Ð©ÓÅ»¯¼ìË÷µÄÉèÖã¬ÔÚ´´½¨Ë÷Òýʱ¼ÓÈëFILTERÑ¡ÏîµÄÉèÖã¬Ôٴγ¢ÊÔ¼ìË÷£¬ÖÕÓÚOK.......ÄÚÅ£ÂúÃæ
Ìù³ö½Å±¾£º
--ÓÅ»¯¼ìË÷Ìõ¼þ
begin
ctx_ddl.create_preference('mylex','BASIC_LEXER');
ctx_ddl.set_attribute('mylex','printjoins','_-');
ctx_ddl.create_preference('mywordlist', 'BASIC_WORDLIST');
ctx_ddl.set_attribute('mywordlist','PREFIX_INDEX','TRUE');
ctx_ddl.set_attribute('mywordlist','PREFIX_MIN_LENGTH',1);
ctx_ddl.set_attribute('mywordlist','PREFIX_MAX_LENGTH', 5);
ctx_ddl.set_attribute('mywordlist','SUBSTRING_INDEX', 'YES');
end;
/
begin
ctx_ddl.create_preference('cnlex','CHINESE_LEXER');
end;
/
--ÉèÖÃË÷Òý²ÎÊý£¬´´½¨Ë÷Òý
drop index t_fileinfo_idx force;
create index t_fileinfo_idx on fileinfo(text)
indextype is ctxsys.context
parameters ('DATASTORE CTXSYS.DIRECT_DATASTORE FILTER C
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
Ò»¡¢Á¬½Ó¹æÔò£¬Ò»ÇвÙ×÷µÄÇ°Ìá¡£ µÍ°æ±¾¿Í»§¶ËÄܹ»Á¬½Óµ½Í¬Ñù°æ±¾»òÕ߸ü¸ß°æ±¾µÄ·þÎñÆ÷ÉϽøÐÐimpºÍexp²Ù×÷¡£ ¸ß°æ±¾¿Í»§¶Ë²»ÄÜÁ¬½Óµ½µÍ°æ±¾µÄ·þÎñÆ÷ÉϽøÐÐimp»òÕßemp²Ù×÷¡£ ¶þ¡¢»ìºÏʹÓùæÔò£¬Ç°ÌáÊÇÒªÂú×ãÁ¬½Ó¹æÔò¡£ µÍ°æ±¾exp³öµÄdmpÎļþ£¬Óø߰汾Äܹ»imp½øÈ¥¡£ ¸ß°æ±¾exp³öµÄdmpÎļþ£¬µÍ°æ±¾µÄimp¹¤¾ß² ......
Ò»¡¢PL/SQL±à³Ì¹æ·¶Ö®´óСд
¾ÍÏñÔÚSQLÖÐÒ»Ñù£¬PL / SQLÖÐÊDz»Çø·Ö´óСдµÄ¡£ÆäÒ»°ã×¼ÔòÈçÏ£º
¹Ø¼ü×Ö(BEGIN, EXCEPTION, END, IF THEN ELSE,LOOP, END LOOP)¡¢Êý¾ÝÀàÐÍ(VARCHAR2, NUMBER)¡¢ÄÚ²¿º¯Êý(LEAST, SUBSTR)ºÍÓû§¶¨ÒåµÄ×Ó³ÌÐò(procedures, functions,packages)£¬Ê¹Óôóд¡£
±äÁ¿ÃûÒÔ¼°SQLÖеÄÁÐÃûºÍ±íÃû£¬Ê¹ÓÃÐ ......
ÍêÈ«¸ÉµôOracleËÀËø½ø³Ì
1.²éÄĸö¹ý³Ì±»Ëø:
²éV$DB_OBJECT_CACHEÊÓͼ:SELECT * from V$DB_OBJECT_CACHE WHERE OWNER='¹ý³ÌµÄËùÊôÓû§' AND CLOCKS!='0';
2. ²éÊÇÄÄÒ»¸öSID,ͨ¹ýSID¿ÉÖªµÀÊÇÄĸöSESSION:
²éV$ACCESSÊÓͼ:SELECT * from V$ACCESS WHERE OWNER='¹ý³ÌµÄËùÊôÓû§' AND NAME='¸Õ²Å²éµ½µÄ¹ý³ÌÃû';
3. ²é³öSI ......