oracle 10gÖÐÎİæµÄÔÚÄÄÀïÏÂÔØ£¿£¿£¿
oracle 10gÖÐÎİæµÄÔÚÄÄÀïÏÂÔØ£¿
oracle¹Ù·½ÓÐÏ嵀 ÕâÊǹúÄÚµÄ Oracle 10.1 for windows http://www.verycd.com/topics/69583/ Oracle 10.2 for linux http://www.verycd.com/topics/57759/ windows Ï Oracle 10.1ÊÇ×îа汾Âð£¿ÒýÓà oracle 10gÖÐÎİæµÄÔÚÄÄÀïÏÂÔØ£¿ Ö±½Ó´Ó¹ÙÍøÏ°²×°Îļþ¾Í¿ÉÒÔÁË£¬ÔÚ°²×°µÄʱºò»áÌáʾÄãÑ¡ÔñÓïÑÔ£¬ÄÇÊÇÑ¡ÔñÖÐÎĵľͿÉÒÔÁË¡£ ÏÖÔÚ×îеÄÊÇOracle 11gµÄ. ------------------------------------------------------------------------------ Blog£º http://blog.csdn.net/tianlesoftware ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net Ïà¹ØÊÓÆµ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx DBA1 Ⱥ£º62697716(Âú); DBA2 Ⱥ£º62697977 ÎÒÓõÄOracle 10g 10g½¨Òéµ½ORACLE¹ÙÍøÉÏÏÂÔØ£¬ÏÂÔØÇ°ÏÈ×¢²áÐÂÓû§¾Í¿ÉÒÔÁË http://www.verycd.com/topics/69583/ µ«Êǽ¨Òéһϣ¬Èç¹ûÄãwin 7 osµÄ×îºÃµ½¹ÙÍøÏÂÔØ11g£¬ºÃÏñ10gµÄos°æ±¾ÊÇ6.0£¬¶ø7 ÊÇ6.1£¨ÐèÒªÐÞ¸Äһϣ¬Ìí¼ÓÒ»¶Î´úÂë¾ÍºÃÁË£© ¿ÉÄÜ11g µÄ¼æÈÝÐԺõ㣬¿´¸öÈ˵ÄÑ¡Ôñà¶¡£¡£¡£ Ö±½Ó´Ó¹Ù·½Ï°¡ ÎÒÔÚ¹ÙÍøÉϵãÁË¡°ÊÊÓÃÓÚ Microsoft Windows£¨32 룩µÄ Oracle Êý¾Ý¿â 10g µÚ 1 °æ (10.1.0.2)¡±Õâ¸öÁ´½Ó£¬Ìø×ªµÄÒ³ÃæÈ´ÊÇÓ¢Îĵ쬱¾È˲»Ì«»áÍæÓ¥£¬²»ÖªµÀÏÂÒ»²½¸ÃÔõô°ìÁË¡£ ÇóÖú£¡£¡£¡ ÄÇû°ì·¨£¬Ö»ÓÐÒ»µãÒ»µã¿´£¬Èç¹ûÏÂÔØµÄʱºò¾ÍÄÇôһµãÓ¢Îͼ²»Ô¸Òâ¿´£¬ÄãÒÔºóѧϰ¿´Ó¢ÎÄÎĵµ¸üÍ´¿à¡£
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ ÒýÓà ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏ Errors in file /user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902: error in executing ODCIIndexStart() routine ORA-0 ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨ ÒýÓà °²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
SQL code: declare v_deptno number(2); v_dname varchar2(14); begin dbms_output.put_line('ÇëÊäÈ벿ÃźźͲ¿ÃÅÃû:'); v_deptno:=&deptno; v_dname:='&dname'; insert into dept01(deptno,dnam ......