oracle odbcÁ¬½ÓÎÊÌâ
ÎÒÔÚʹÓÃodbcÊý¾ÝÔ´µÄʱºò£¬ÎÒµÄÊý¾ÝÔ´ÏÔʾΪoracle in oraDB10g_home1
¶øÔÚµã»÷Ìí¼ÓʱÏÔʾµÄȴΪoracle in oraDB10g_home3
Ë«»÷Êý¾ÝԴʱ±¨´í£¬ÕÒ²»µ½oracleµÄÇý¶¯
ËÄܰïÖú½â¾öһϣ¡£¡£¡£¡
лл
Äã°²×°Á˶à´Îoracle?
Ö»ÓÐÑ¡ÔñÊý¾ÝÔ´Çý¶¯Ê±ÏÔʾ
»¹ÓÐÄĶùÏÔʾ£¿
µ½ÍøÉϵ´¸öoracleÇý¶¯°ü ¼ÓÔØµ½³ÌÐòÖÐ
È¥×¢²á±í°ÑÒÔǰ°²×°ÒÅÁôÏÂÀ´µÄ¶«Î÷ɾµôÓ¦¸Ã¿ÉÒÔ
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......