oracleµÄÊý¾Ý¿â½á¹¹£¿
¸Õ½Ó´¥oracle£¬ÓеãÃÉ
ÒÔǰÔÚ×öÍøÕ¾µÄʱºò£¬ÓÃsql2000,¸ø¿Í»§½¨Á¢Ò»¸öÊý¾Ý¿â,data1,Ö®ºó½¨Á¢Ò»¸öÓû§user1£¬°Ñdata1µÄȨÏÞ¸øuser1ºó£¬¾Í¿ÉÒÔÁ˵Ä
½á¹¹ÊÇ£ºÊý¾Ý¿â(date1)
±í tab1
×Ö¶Î id,username,pwd,levels,Tusername
±í news
×Ö¶Î id,title,infos,content
±í partd
×Ö¶Î id,partd,title
ÊÇÕâÑùµÄ½á¹¹¿´×Åͦ·½±ãµÄ
×öoracleµÄʱºò£¬±ðÈ˺ÍÎÒ˵ûÓÐÊý¾Ý¿â£¬¶¼ÊÇÓû§£¿
¸øÎҵĸоõÊÇ£º
ÏȽ¨Á¢Ò»¸öÓû§Ouser1
Ö®ºóÔÚÕâ¸öÓû§Ï½¨Á¢±íOtab1
×Ö¶Î id,username,pwd,levels,Tusername
±í news
×Ö¶Î id,title,infos,content
ÊÇÕâÑùµÄÂð£¿
»¹Óбí¿Õ¼ä
ËùÓÐµÄ±í¶¼ÔÚ±í¿Õ¼äÀ֮ºóÓû§¹ÜÀí±í¿Õ¼ä£¿
ÄÇÕâ¸ö ±í¿Õ¼ä ÊDz»ÊǾÍÊÇÊý¾Ý¿âµÄ¸ÅÄҲÊÇÒª ÏȽ¨Á¢±í¿Õ¼ä£¬Ö®ºó ²ÅÄܽ¨Á¢±í£¿
oracleÊý¾Ý¿âÊÇÖ¸Ò»×éλÓÚ´ÅÅÌÉϵÄÊý¾ÝÎļþµÄ¼¯ºÏ
oracleʵÀýÊÇÖ¸Ò»×éºǫ́½ø³ÌºÍÒ»×éÄÚ´æ×é¼þ
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
ÓÃ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à ......