oracleÈ«ÎÄË÷ÒýÖ®WORDLIST PREFERENCE
OracleÈ«ÎÄË÷ÒýµÄWORDLISTÊôÐÔÓÃÀ´ÉèÖÃÄ£ºý²éѯºÍͬ´Ê¸ù²éѯ£¬ÁíÍâWORDLISTÊôÐÔ»¹Ö§³ÖͨÅä·û²éѯ¡£
OracleµÄWORDLISTÊôÐÔÖ»ÓÐBASIC_WORDLISTÒ»ÖÖ£¬ÏÂÃæ¿´Ò»¸öBASIC_WORDLISTµÄÀý×Ó£º
1.Stemmer attributeÊÇÓÃÀ´²éѯÓôʸùµÄÊý¾Ý
SQL> create table stemmer_tbl(id number primary key,docs clob);
Table created.
SQL> insert into stemmer_tbl values(111,'We are testing the Stemmer attribute option');
1 row created.
SQL> insert into stemmer_tbl values(112,'The girl sang like a frog');
1 row created.
SQL> insert into stemmer_tbl values(113,'My import is committing too often');
1 row created.
SQL> commit;
Commit complete.
--
-- Basic WordList Stemmer attribute
-- This example uses English for Stemming.
-- Language choices are: NULL,ENGLISH,DERIVATIONAL,DUTCH,FRENCH,GERMAN,ITALIAN
-- and SPANISH. By default we use the language of the database. If the
-- database is not one of the listed languages then we choose NULL for stemmer
-- and default for fuzzy
--
SQL> begin
2 Ctx_Ddl.Create_Preference('STEMMER_PREF', 'BASIC_WORDLIST');
3 ctx_ddl.set_attribute('STEMMER_PREF','STEMMER','ENGLISH');
4 end;
5 /
PL/SQL procedure successfully completed.
SQL> create index stemmer_idx on stemmer_tbl ( docs )
2 indextype is ctxsys.context
3 parameters ('Wordlist STEMMER_PREF');
Index created.
SQL> column docs format a20
SQL> select id,docs,score(1) from stemmer_tbl
2 where contains ( docs, '$test',1 ) > 0;
ID DOCS SCORE(1)
---------- -------------------- ----------
111 We are testing the S 4
temmer attribute opt
ion
SQL> select id,docs,score(1) from stemmer_tbl
2 where contains ( docs, '$sing',1) >0;
ID DOCS SCORE(1)
---------- -------------------- ----------
112 The girl sang like a 4
frog
µÚÒ»¸ö²éѯÊDzétestµÄÕÒ³ötesting£¬Õâ¸ö²»Ì«Ã÷ÏÔ£»µÚ¶þ¸öÊÇÕҴʸùÊÇsingµÄÊý¾Ý£¬ÕÒµ½ÁËsangµÄÕâÒ»ÐÐÊý¾Ý¡£
Ïà¹ØÎĵµ£º
http://hi.baidu.com/james_yulei/blog/item/7cc8c834063d6f3a0b55a920.html
OracleÊý¾Ý¿âRMANµÄ×Ô¶¯±¸·Ý½Å±¾
2009-12-21 18:04
OracleÊý¾Ý¿âRMANµÄ×Ô¶¯±¸·Ý½Å±¾
²Ù×÷ϵͳ£ºLinux
Êý¾Ý¿â£ºoracle9.2.0.4
1¡¢Êý¾Ý¿âÉèÖÃΪ¹éµµ·½Ê½
2¡¢Êý¾Ý¿âµÄ±¸·Ý½Å±¾
db_full_backup.sh £ºÊý¾Ý¿âÈ«±¸½Å±¾
db_l0_backup.sh £ºÊý¾Ý¿ ......
Ò»¡£jobµÄÔËÐÐÆµÂÊÉèÖÃ
1.ÿÌì¹Ì¶¨Ê±¼äÔËÐУ¬±ÈÈçÔçÉÏ8:10·ÖÖÓ£ºTrunc(Sysdate+1) + (8*60+10)/24*60
2.ToadÖÐÌṩµÄ£º
ÿÌ죺trunc(sysdate+1)
ÿÖÜ£ºtrunc(sysdate+7)
ÿÔ£ºtrunc(sysdate+30)
ÿ¸öÐÇÆÚÈÕ£ºnext_day(trunc(sysdate),'SUNDAY')
ÿÌì6µã£ºtrunc(sysdate+1)+6/24
°ë¸öСʱ£ºsysdate+30/1440
3.ÿ¸ö ......
¼ÌÐøÌÖÂÛÈ«ÎÄË÷ÒýµÄDATASTOREÊôÐÔ£¬½éÉÜMULTI_COLUMN_DATASTORE¡£
Èç¹û±»Ë÷ÒýµÄÎÄÕÂÊDZ£´æÔÚÊý¾Ý¿âÖУ¬µ«ÊÇÄÚÈÝ·Ö²¼ÔÚ¶à¸öÁÐÖУ¬ÄÇô¿ÉÒÔͨ¹ý½¨Á¢Ò»¸öMULTI_COLUMN_DATASTOREÀ´Ë÷ÒýÍêÕûµÄÎÄÕ£º
SQL> CREATE TABLE T (ID NUMBER, DOC1 VARCHAR2(4000), DOC2 VARCHAR2(4000), DOC3 VARCHAR2(4000));
±íÒÑ´´½ ......
½éÉÜÍêOracleÈ«ÎÄË÷ÒýµÄFILTERÊôÐÔ£¬¼ÌÐø½éÉÜOracleµÄLEXERÊôÐÔ¡£
OracleÈ«ÎÄË÷ÒýµÄLEXERÊôÐÔÓÃÓÚ´¦Àí¸÷ÖÖ²»Í¬µÄÓïÑÔ¡£×î»ù±¾µÄÓ¢ÎÄʹÓÃBASE_FILTER£¬¶øÈç¹ûÐèҪʹÓÃÖÐÎÄÔò¿ÉÒÔʹÓÃCHINESE_VGRAM_LEXER»òCHINESE_LEXER¡£
ÕâÆªÎÄÕ¼òµ¥ËµÃ÷BASIC_LEXERÊôÐÔ¡£BASIC_LEXERÊôÐÔÖ§³Ö¶àÖÖÓïÑÔ£¬±ÈÈçÓ¢Óï¡¢µÂÓï¡¢ºÉÀ¼ÓŲ ......