ÇóoracleÊý¾Ý¿â±¸·ÝÃüÁî
ÈçÌ⣺
ÇóÒ»±¸·ÝoracleÊý¾Ý¿âµÄÍêÕûÃüÁÐèÒªÕû¿â±¸·Ý¡£Ð»Ð»
±¸·ÝÃüÁî,¾ÍÊǵ¼³öÊý¾Ý!LIUNXÏ¿ÉÒÔд½Å±¾,¶¨Ê±±¸·Ý!ÉÏÍø²éÒ»ÏÂ,ºÜ¶àÀý×Ó!
exp USERNAME/PASSWORD@Êý¾Ý¿âÁ¬½Ó·û full=y file='Ä㱸·ÝÎļþ´æ·ÅµÄ·¾¶'
exp scott/scott@orcl full=y file='/oracle/oracle10g/backup/allbackup_scott_20090917.bmp';
Â¥ÉϵÄÕý½â
²»Óöà˵ÁË
cmd ÏÂ
exp uid/pwd@sid file=d:\orcl.dmp owner=(uid1,uid2...)
¸÷λ´óÏÀ£º
ÎÒÔÚpl/sqlÖÐÊäÈëµÄÃüÁîÊÇ£º
exp xcom_test/xcom_test@rasdb file='e:\orc.dmp';
ÎÒµÄÊý¾Ý¿âÁ¬½Ó×Ö·û´®ÊÇ£º
<property name="url"> <value>jdbc:oracle:thin:@**.**.**.**:1521:rasdb </value>
</property>
<property name="user">
<value>xcom_test </value>
</property>
<property name="password">
<value>xcom_test </value>
</property>
ÎÒÖ´ÐÐÃüÁ´í£ºORA-00900: invalid SQL statement
ѧϰ
ÎÊÌâÒѽâ¾ö£¬ÏÖÔÚ½áÌù¡£
лл´ó¼Ò²ÎÓë¡£
Ïà¹ØÎÊ´ð£º
±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......
ÎÒ´óרѧÀú£¬ÔÚÒ»¼Ǫ̀×Ê ¼¯ÍÅµÄ ·Ö¹«Ë¾ ×öÀ²Ò»Äê´óÐÍERPÈí¼þ¿ª·¢&ά»¤£¬ÏëÔÚÖ麣ÕÒ·Ý.netµÄ¹¤×÷£¬Òª¶àÉÙ¹¤×ʺÏÊÊ£¿
¿ªÊ¼²»ÒªÌ«¸ß£¬3K×óÓÒÓ¦¸ÃÊDZê×¼
Ö麣ÄDZßËÆºõûÉîÛÚºÃ.
Èç¹ûÊÇÎҵϰ,Ê×ÏÈÊÇÒª±ÈÏ ......
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
¸½Í¼Æ¬ ......
Óиö´æ´¢¹ý³ÌÓÐÈý¸öInt²ÎÊýºÍÒ»¸öOut²ÎÊý.
Ö´ÐÐʱÏȽ«Ò»Ð©Êý¾Ý²åÈëµ½Ò»¸ö±íÖÐ.È»ºóÔÙ´Ó±íÖÐÈ¡³öÊý¾Ý½øÐÐÐÐתÁÐ,ºÏ¼ÆµÈÂß¼.½«´¦Àí½á¹û·Åµ½Ò»¸ö±íÖÐ.²¢½«Idͨ¹ýOut²ÎÊý·µ»Ø.
µ«ÔÚÖ´ÐÐʱ¿ÉÒÔ»ñÈ¡µ½OutÖµ,µ«¾ÍÊÇà ......
¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮
ÎÒÉèÖÃÁËÒ»¸öoracle×ֶΣ¬varchar(3000),È»ºó²åÈëÒ»ÌõÊý¾Ý³¤¶È²Å1000,¾Í±¨´íÁË£®È磺net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
Caused ......