oracle 10°²×°µÄÎÊÌâ
³õѧoracle ÇëÎÊϰ²×°oracleÊDz»ÊDZØÐëÔÚ´øÍøÂçÁ¬½ÓµÄµÄÌõ¼þϰ²×°£¿ËÞÉáûÁªÍø£¬Ã¿´Î°²×°¶¼µ½79%×óÓҾ͵¯³ö°²×°½áÊø£¬Ã»ÓÐconfiguration assistant ÅäÖùý³Ì£¬Í˳ö°²×°Ò²Ã»Óе¯³öÊý¾Ý¿âµÇ½½çÃæ¡£ ÔËÐÐSQL PLUS ÎÞ·¨µÇ½£ºÎÞ·¨½âÎöÖ¸¶¨×Ö·û Çë¸ßÈ˽âÊÍÏ····
²»ÐèÒªÁªÍø¼´¿É°²×°£¬¿ÉÒÔ¿´ÏÂÈÕÖ¾Îļþ ºÃÏñÊÇÓÐÕâ¸öÎÊÌâ¡£ÎÒÒÔǰҲÓöµ½¹ý¡£×°¸övmÀ´×öʵÑéÓ´¡£ÒýÓà ºÃÏñÊÇÓÐÕâ¸öÎÊÌâ¡£ÎÒÒÔǰҲÓöµ½¹ý¡£×°¸övmÀ´×öʵÑéÓ´¡£ ÎÒ×öÌì×°Á˸ö ÐéÄâÍø¿¨£¬ÎÊÌâÒÀ¾É···· ²»ÓÃÁªÍøÒ²¿ÉÒÔ°²×°µÄ Èç¹ûûÓа²×°ÍêÈ«µÄ»°£¬¹À¼ÆÊǰ²×°ÎļþµÄÎÊÌâ¡£¡£¡£½¨ÒéÖØÐÂÏÂÔØÒ»¸ö°²×°ÎļþÀ´ÊÔÊÔ ¿ªÊ¼-->³ÌÐòÀïÓÐOracle - OraDbX_home1µÄ»°£¬ÊÖ¹¤°²×°Êý¾Ý¿âÊÔÊÔ LZÇ뱨ÄãµÄϵͳ»·¾³£¬ºÍoracle¾ßÌå°æ±¾ºÅ ÎÒн¨ÁËÒ»¸ö´¿×ÖĸÕË»§ °²×°ÁËÐéÄâÍø¿¨ È»ºóжװËùÓÐOracle²úÆ· ɾ³ýHKEY_LOCAL_MACHINE\SOFTWARE\ORACLE HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\ServicesÀïûÕÒµ½ORACLEÏà¹Ø È»ºóÖØÆôɾ³ýC:\Oracle ÔÙ°²×° ¾Í³É¹¦ÁË···
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ ÒýÓà ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó #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£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......