¹ØÓÚMSSQL¼°OracleÊý¾Ý¿âÖеÄËøÓë²¢·¢µÄС½á
×î½ü£¬¹¤×÷µÄÉÏÐèÒª´¦ÀíÒ»ÏÂÏîÄ¿Öеļ«ÉÙÁ¿Êý¾ÝµÄÖظ´ÎÊÌâ¡£¾¹ý·ÖÎö£¬½á¹û·¢ÏÖÊdzÌÐò²¢·¢Ã»Óд¦ÀíºÃ¶øµ¼Öµġ£¾¹ýÒ»·¬ÃþË÷£¬¶ÔÊý¾Ý¿âÖеÄËø¼°³ÌÐòµÄ²¢·¢ÓÐÁËÒ»µãµãСµÄÐĵá£ÌØдµ½´ËÀ´Óë´ó¼Ò·ÖÏíһϡ£
Ê×ÏÈ£¬ÎÒÃÇÀ´Á˽âÒ»ÏÂʲô½Ð×öËø¡£
ÎÒÃÇÔÙÀ´¿´¿´ËøµÄ·ÖÀà¡¢×÷Óü°Óë³ÌÐò²¢·¢ÐԵĹØϵ¡£
Á˽âÁËÕâô¶à¡£×îÖØÒªµÄµ±È»¾ÍÊÇÈçºÎʹÓÃËøÀ²¡£ÏÂÃæÎÒÃÇÒ»ÆðÀ´Á˽âÒ»ÏÂÈçºÎʹÓÃËø°É¡£
Ïà¹ØÎĵµ£º
ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆ𣬾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......
¡¾IT168 ¼¼ÊõÎĵµ¡¿Ëæ×ÅÍøÂçÓ¦Óú͵ç×ÓÉÌÎñµÄ²»¶Ï·¢Õ¹£¬¸÷¸öÕ¾µãµÄ·ÃÎÊÁ¿Ô½À´Ô½´ó£¬ÈçºÎʹÓÐÏ޵ļÆËã»úϵͳ×ÊԴΪ¸ü¶àµÄÓû§·þÎñ£¿ÈçºÎ±£Ö¤Óû§µÄÏìÓ¦ËٶȺͷþÎñÖÊÁ¿£¿ÕâЩÎÊÌⶼÊôÓÚ·þÎñÆ÷ÐÔÄÜÓÅ»¯µÄ·¶³ë¡£×÷Ϊ½Ï³É¹¦µÄÊý¾Ý¿â³§ÉÌ£¬Oracle¹«Ë¾Êý¾Ý¿âµÄÐÔÄÜÓÅ»¯ÊÇÈçºÎ½øÐеÄ
¡¡¡¡ ÓÅ»¯²ßÂÔ
¡¡¡¡ ΪÁ˱£Ö¤OracleÊý ......
¼ÌÐøÌÖÂÛÈ«ÎÄË÷ÒýµÄ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ÊôÐÔÖ§³Ö¶àÖÖÓïÑÔ£¬±ÈÈçÓ¢Óï¡¢µÂÓï¡¢ºÉÀ¼ÓŲ ......
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.
S ......