oracleÈ«ÎÄË÷ÒýÖ®LEXER
½éÉÜÍêOracleÈ«ÎÄË÷ÒýµÄFILTERÊôÐÔ£¬¼ÌÐø½éÉÜOracleµÄLEXERÊôÐÔ¡£
OracleÈ«ÎÄË÷ÒýµÄLEXERÊôÐÔÓÃÓÚ´¦Àí¸÷ÖÖ²»Í¬µÄÓïÑÔ¡£×î»ù±¾µÄÓ¢ÎÄʹÓÃBASE_FILTER£¬¶øÈç¹ûÐèҪʹÓÃÖÐÎÄÔò¿ÉÒÔʹÓÃCHINESE_VGRAM_LEXER»òCHINESE_LEXER¡£
ÕâƪÎÄÕ¼òµ¥ËµÃ÷BASIC_LEXERÊôÐÔ¡£BASIC_LEXERÊôÐÔÖ§³Ö¶àÖÖÓïÑÔ£¬±ÈÈçÓ¢Óï¡¢µÂÓï¡¢ºÉÀ¼ÓŲÍþÓï¡¢ÈðµäÓïµÈµÈ¡£
BASIC_LEXER³ýÁËÖ§³Ö¶àÖÖÓïÑÔ£¬»¹¿ÉÒÔÉèÖöàÖÖÊôÐÔ¡£±ÈÈçÕâ¸öÀý×ÓÖнéÉܵÄË÷ÒýµÄ´óСдÉèÖãº
SQL> CREATE TABLE T (ID NUMBER, DOCS VARCHAR2(1000));
±íÒÑ´´½¨¡£
SQL> INSERT INTO T VALUES (1, 'This is a example for the basic lexer');
ÒÑ´´½¨ 1 ÐС£
SQL> INSERT INTO T VALUES (2, 'And we make a example for a mixed spell indexs.');
ÒÑ´´½¨ 1 ÐС£
SQL> INSERT INTO T VALUES (3, 'So the word in UPPER format must be query in UPPER');
ÒÑ´´½¨ 1 ÐС£
SQL> INSERT INTO T VALUES (4, 'And Mixed Spell Word must be Query in Mixed.');
ÒÑ´´½¨ 1 ÐС£
SQL> COMMIT;
Ìá½»Íê³É¡£
SQL> CREATE INDEX IND_T_DOCS ON T (DOCS) INDEXTYPE IS CTXSYS.CONTEXT
2 PARAMETERS ('LEXER CTXSYS.BASIC_LEXER');
Ë÷ÒýÒÑ´´½¨¡£
SQL> SELECT ID from T WHERE CONTAINS(DOCS, 'MIXED') > 0;
ID
----------
4
2
SQL> DROP INDEX IND_T_DOCS;
Ë÷ÒýÒѶªÆú¡£
SQL> CONN CTXSYS/CTXSYS@YANGTK
ÒÑÁ¬½Ó¡£
SQL> BEGIN
2 CTX_DDL.CREATE_PREFERENCE('TEST_BASIC_LEXER', 'BASIC_LEXER');
3 CTX_DDL.SET_ATTRIBUTE('TEST_BASIC_LEXER', 'MIXED_CASE', 'YES');
4 END;
5 /
PL/SQL ¹ý³ÌÒѳɹ¦Íê³É¡£
SQL> CONN YANGTK/YANGTK@YANGTK
ÒÑÁ¬½Ó¡£
SQL> CREATE INDEX IND_T_DOCS ON T (DOCS) INDEXTYPE IS CTXSYS.CONTEXT
2 PARAMETERS ('LEXER CTXSYS.TEST_BASIC_LEXER');
Ë÷ÒýÒÑ´´½¨¡£
SQL> SELECT ID from T WHERE CONTAINS(DOCS, 'MIXED') > 0;
δѡ¶¨ÐÐ
SQL> SELECT ID from T WHERE CONTAINS(DOCS, 'Mixed') > 0;
ID
----------
4
Èç¹û²»½øÐÐÉèÖã¬OracleÔÚ½¨Á¢Ë÷Òýʱ»á½«ËùÓеÄ×Öĸ±äΪ´óд¡£Èç¹û½øÐÐÁËÉèÖ㬿ÉÒÔʹË÷ÒýÇø·Ö´óСд
½éÉÜÍêOracleÈ«ÎÄË÷ÒýµÄBASIC_LEXERÊôÐÔ£¬Õâƪ½éÉÜOracleÖÐÎÄÓï·¨ÊôÐÔCHINESE_LEXERºÍCHINESE_VGRA
Ïà¹ØÎĵµ£º
ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆ𣬾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......
extent--×îС¿Õ¼ä·ÖÅ䵥λ --tablespace management
block --×îСi/oµ¥Î» --segment management
create tablespace james
datafile '/export/home/oracle/oradata/james.dbf'
size 100M ¡¡¡¡¡¡¡¡¡¡¡¡--³õʼµÄÎļþ´óС¡¡
autoextend On¡¡¡¡¡¡¡¡ --×Ô¶¯Ôö³¤
next 10M¡ ......
Óöµ½µÄһЩOracleµÄÁãËéÎÊÌ⣺
1¡¢Ê¹ÓÃ×Ô¶¨ÒåÒì³££¬raise_application_error(Òì³£±àºÅ£¬Òì³£ÐÅÏ¢)¡£
A¡¢Òì³£±àºÅ×¢Òâ²»Òª³¬³¤£¬Ò»°ãµ½5λ
B¡¢Òì³£ÐÅÏ¢ÊÇÒ»¸ö×Ö·û´®ÐÅÏ¢
C¡¢ÅäºÏ´æ´¢¹ý³ÌÖÐexceptionʹÓà ......
¼ÌÐøÌÖÂÛÈ«ÎÄË÷ÒýµÄDATASTOREÊôÐÔ£¬½éÉÜMULTI_COLUMN_DATASTORE¡£
Èç¹û±»Ë÷ÒýµÄÎÄÕÂÊDZ£´æÔÚÊý¾Ý¿âÖУ¬µ«ÊÇÄÚÈÝ·Ö²¼ÔÚ¶à¸öÁÐÖУ¬ÄÇô¿ÉÒÔͨ¹ý½¨Á¢Ò»¸öMULTI_COLUMN_DATASTOREÀ´Ë÷ÒýÍêÕûµÄÎÄÕ£º
SQL> CREATE TABLE T (ID NUMBER, DOC1 VARCHAR2(4000), DOC2 VARCHAR2(4000), DOC3 VARCHAR2(4000));
±íÒÑ´´½ ......
DATASTOREÊÇFILE_DATASTOREµÄ²âÊÔ
[oracle@rhel140 ~]$ cat OUTPUT.TXT
ORACLE
oracle
[oracle@rhel140 LOG]$ cat EMPXT_000_2012_2680.LOG
SOURCE
ABC
SQL> conn myuser/myuser
Connected.
SQL> CREATE TABLE T (ID NUMBER, DOCS VARCHAR2(1000));
Table created.
SQL> INSERT INTO T VALUES (1, 'OUT ......