Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÇëÎÊÏÂѧϰ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µÄ¹Ù·½Êֲᡣ£¨·½±ãÒÔºó²éÕÒ£¬±ÜÃâÀàËÆÓÚ¿¼ÊÔµÄʱºò£¬¸øÄã±¾ÕþÖÎÊéÒ²²»ÖªµÀ´ð°¸ÔÚµÚ¼¸Õ


Ïà¹ØÎÊ´ð£º

ÊÇoracleµÄbugô£¿É¢·ÖÁË£¡ - 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 ·ÖÒ³ - Java / Web ¿ª·¢

´ó¼ÒÓöµ½ORACLE·ÖÒ³¶¼ÊÇÔõô´¦ÀíµÄ£¿
ÊÇÓÃSQLÓï¾ä·ÖÒ³£¿»¹ÊÇÓÿɹö¶¯µÄ½á¹û¼¯·ÖÒ³£¿
Ï£Íû´ó¼ÒÄܰѴúÂëÌù³öÀ´¡£
×îºó´ó¼Ò¸Ð¾õÄÄÖÖЧÂʸߣ¿ÎªÊ²Ã´£¿
ÒªÊÇÓÃhibernateµÄ»°£¬¾Í²»ÓùÜÊDz»ÊÇoracleÁË¡£
ÎÒÖ»ÖªµÀorac ......

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

OracleµÄblob×Ö¶ÎÎÊÌâ - Oracle / ¿ª·¢

²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ