Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ORACLE OleDbÁ¬½Óoracle 10G´íÎó

¿ª·¢¹¤¾ßÊÇC#£¬Ð´µÄC/SģʽµÄ³ÌÐòʹÓÃORACLE OleDbµÄ·½Ê½Á¬½Óoracle 10GÊý¾Ý¿â£¬Õý³£²Ù×÷ûÎÊÌ⣬ֻҪһ·ÖÖÓ²»²Ù×÷£¬È»ºóÓ¦ÓóÌÐò¼ÌÐø¶ÔÊý¾Ý¿â²Ù×÷¾Í»á±¨³ö¡°Ã»ÓпÉÓõĴíÎóÐÅÏ¢£¬´íÎó´úÂ룺E_FAIL(0x80004005)¡±£¬ÊDz»ÊÇoracleÀïÓÐʲô²ÎÊýÒªÉèÖ᣻òÕ߿ͻ§¶ËʹÓÃORACLE OleDÁ¬½ÓÊý¾Ý¿âʱÓÐʲôÏÞÖÆ¡£
Èç¹ûÓÃsqlplusµÇ¼oracle£¬³¬¹ý1·ÖÖÓ²»²Ù×÷£¬»áÓÐÕâÑùµÄÇé¿öÂð


Ïà¹ØÎÊ´ð£º

ÊÇoracleµÄbugô£¿É¢·ÖÁË£¡ - Oracle / »ù´¡ºÍ¹ÜÀí

±¾À´ÒªÐ´¸öupdateÓï¾ä
update table_a A
  set A.flag=1
  where A.id in (select B.id from table_b B)
½á¹ûÎóд³É
update table_a A
  set A.flag=1
  where ......

oracleµ¼Èë»Ø¹ö - Oracle / ¿ª·¢

abnormal end of export file
IMP-00028: partial import of previous table rolled back: 3828 rows rolled back
  
ÓÐûÓÐÒ»ÖÖ·½·¨Èõ¼Èë¼ÌÐø½øÐжø²»Òì³£Ìø³ö»Ø¹ö£¿
ignore=y

Äã² ......

developer suiteÁ´½Óµ½oracle·þÎñÆ÷

Developer SuiteÁ¬½ÓÊý¾Ý¿âµÄÎÊÌ⣬ÀͼݸßÊÖÖ¸µã£¡
µçÄÔÀïÃæÍ¬Ê±×°ÁËOraHome92ºÍDevSuiteHome2£¬Ç°ÕßµÄsql*plusÄÜ·ÃÎÊ£¬ºóÕßµÄÔò²»ÐС£ÊäÈëscott/tigerµÇ½ºóÕßʱ£¬ÎÒÊäÈëÁË"Ö÷»ú×Ö·û´®"ºÅÒԺ󣬱¨´í£º&n ......

oracle ÊÔͼÎÊÌ⣬Çë¸ßÊÖ°ïæ£¬ÔÚÏßµÈ.....

ÎÊÌâÃèÊö£º
1¡¢¼ÙÉèÓбí
t1±í£¬°üº¬ËÄÁÐ
 s1 a b c
 1 a a a
 2 b b b 
.........
t2±í£¬°üº¬2ÁÐ
s2 ff
1 77
2 88
............
ÈçºÎÉú³ÉÕâÑùµÄºÏ²¢Ê ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ