¹ØÓÚoracleÔ¶³ÌÁ¬½Ó¶ÔÏóµÄ·½°¸
»úÆ÷Ò»£º°üº¬ºÜ¶àÊý¾Ý¿â¶ÔÏó Ä¿±ê£º½«ÕâЩÊý¾Ý¿â¶ÔÏóÇ¨ÒÆ³öÒ»²¿·Öµ½Ð»ú2 ÎÊÌ⣺ӦÓõÄÊý¾ÝÁ¬½Ó³ØÖ¸ÏòлúÒ»£¬µ«ÊÇ»¹ÐèÒª·ÃÎÊлú2ÖеÄÓ¦Óá£ÔÚ²»¸Ä±ä´úÂëµÄÇé¿öÏÂÈçºÎ½â¾ö Àý:лú2Óиö¶ÔÏó½Ðtest 1¡£ÒòΪÔÀ´ËùÓжÔÏó¶¼ÔÚһ̨»úÆ÷ÉÏ£¬´úÂëÖвéѯÓï¾äÊÇÕâÑùµÄselect * from test.table; 2¡£²ð·ÖÍêÖ®ºóÈç¹ûÊÇÓÃDB_LINKµÄ·½Ê½µÄ»°£¬ÐèÒªÕâÑù²éѯselect * from test.table@лú2,ºÜ¶àÓ¦Óò»ÄÜËùÓÐÓ¦Óö¼Ð޸İɡ£ËùÒÔ£¬¿¼ÂÇÔÚÊý¾Ý¿âÖÐ×öЩ²Ù×÷£¬Ê¹²éѯ·½Ê½Îªselect * from test.tableÒÀÈ»Äܲé³öÄ¿±êÊý¾Ý¡£
°´Óû§µ¼³öÊý¾ÝÔÚµ¼Èëлú2.. ÒýÓà °´Óû§µ¼³öÊý¾ÝÔÚµ¼Èëлú2.. ÎÒ²»ÊÇҪ̸ÂÛÈçºÎµ¼³ö£¬ÎÒÒªÌÖÂÛµÄÊDzéѯ·½Ê½£¬»¹ÏëÏòÒÔǰһÑù£¡ ÔõôûÈ˻ش𰡣¡
Ïà¹ØÎÊ´ð£º
»·¾³£º1.win2003server+oracle9i 2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1 3.oracle sql developer°æ±¾ 1.5.5 ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
......
ÐÖµÜ Í¼¹ÒÁË¡£ <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName" value ......
¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮ ÎÒÉèÖÃÁËÒ»¸öoracle×ֶΣ¬varchar(3000),È»ºó²åÈëÒ»ÌõÊý¾Ý³¤¶È²Å1000,¾Í±¨´íÁË£®È磺net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update Caused ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
ÏÖÔÚÎÒ±¾µØÃ»Óа²×°oracle, µ«plsqldevÐèÒªsqlplus.exeµÈ£¬ÇëÎÊoracle10gÔÚwindowsÐèÒª ÄÄЩexeÎļþ£¬ÄÄλ´ó¸çÄÜ˳±ãÌṩһÏÂQQ£º190565390 ×°oracleµÄʱºò¿ÉÒÔÑ¡ÔñÖ»×°¿Í»§¶ËµÄ ×îÆðÂëҪװoracle£¬ÄãÖ»Ðè×°¿ ......