ÇëÎÊÏÂѧϰoracleµÄ²½Ö裡
ÇëÎÊÏÂѧϰoracleµÄ²½Ö裬×îºÃÄܹ»ÍƼöϺõãµÄÊéŶ£¡£¡ÊDz»ÊÇÏȰÑlinuxѧºÃÔÙѧ£¿£¿Âé·³¸÷λ°ïÖúСµÜÒ»ÏÂŶ£¡Å¶£¡£¡Ð»Ð»ÁËŶ£¡
ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ£¨µÚËİ棩¡· Íõɺ ÈøÊ¦ìÓ ¸ßµÈ½ÌÓý³ö°æÉç (ÕÆÎÕ»ù´¡ÖªÊ¶ºÍ¸ÅÄî) È»ºóÔÙ´ÖÂÔä¯ÀÀÒ»±éoracleµÄ¹Ù·½Êֲᡣ£¨·½±ãÒÔºó²éÕÒ£¬±ÜÃâÀàËÆÓÚ¿¼ÊÔµÄʱºò£¬¸øÄã±¾ÕþÖÎÊéÒ²²»ÖªµÀ´ð°¸ÔÚµÚ¼¸Õ£¬µÚ¼¸Ò³£©ÒýÓà ÇëÎÊÏÂѧϰoracleµÄ²½Ö裬×îºÃÄܹ»ÍƼöϺõãµÄÊéŶ£¡£¡ÊDz»ÊÇÏȰÑlinuxѧºÃÔÙѧ£¿£¿Âé·³¸÷λ°ïÖúСµÜÒ»ÏÂŶ£¡Å¶£¡£¡Ð»Ð»ÁËŶ£¡ ¿ª·¢»¹ÊÇά»¤£¿ ¿ª·¢µÄ»°£¬¿´µãSQL Ïà¹Ø´óµÄÊ飬¶à¶¯ÊÖʵ¼ù¡£ ά»¤µÄ»°£º 1. ²»Í¬Æ½Ì¨µÄ°²×°£¬Éý¼¶ 2. ±¸·ÝÓë»Ö¸´£¬Âß¼±¸·Ý£¬ÎïÀí±¸·Ý£¬RMAN±¸·Ý£¬Êý¾Ý°áǨ 3. Êý¾Ý¿âµÄһЩ»ù±¾²Ù×÷£¬±í£¬±í¿Õ¼ä£¬Êý¾ÝÎļþ£¬¿ØÖÆÎļþ 4. ¸ß¿ÉÓÃÐÔ£¬Data Gurad£¬RAC 4. ÐÔÄܵ÷ÓÅ ¿ÉÒԲο¼ÎÒµÄblog, ÊÇÎÒѧϰOracle һ·×ܽá³öÀ´µÄ¹ý³Ì¡£ ------------------------------------------------------------------------------ Blog£º http://blog.csdn.net/tianlesoftware ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net Ïà¹ØÊÓÆµ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx Q Q Ⱥ£º62697716 ÒýÓà ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ£¨µÚËİ棩¡· Íõɺ ÈøÊ¦ìÓ ¸ßµÈ½ÌÓý³ö°æÉç (ÕÆÎÕ»ù´¡ÖªÊ¶ºÍ¸ÅÄî) È»ºóÔÙ´ÖÂÔä¯ÀÀÒ»±éoracleµÄ¹Ù·½Êֲᡣ£¨·½±ãÒÔºó²éÕÒ£¬±ÜÃâÀàËÆÓÚ¿¼ÊÔµÄʱºò£¬¸øÄã±¾ÕþÖÎÊéÒ²²»ÖªµÀ´ð°¸ÔÚµÚ¼¸Õ
Ïà¹ØÎÊ´ð£º
±¾À´ÒªÐ´¸öupdateÓï¾ä update table_a A set A.flag=1 where A.id in (select B.id from table_b B) ½á¹ûÎóд³É update table_a A set A.flag=1 where ......
´ó¼ÒÓöµ½ORACLE·ÖÒ³¶¼ÊÇÔõô´¦ÀíµÄ£¿ ÊÇÓÃSQLÓï¾ä·ÖÒ³£¿»¹ÊÇÓÿɹö¶¯µÄ½á¹û¼¯·ÖÒ³£¿ Ï£Íû´ó¼ÒÄܰѴúÂëÌù³öÀ´¡£ ×îºó´ó¼Ò¸Ð¾õÄÄÖÖЧÂʸߣ¿ÎªÊ²Ã´£¿ ÒªÊÇÓÃhibernateµÄ»°£¬¾Í²»ÓùÜÊDz»ÊÇoracleÁË¡£ ÎÒÖ»ÖªµÀorac ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó #topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬ Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04 #lslv -l lv04
......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......