ORACLE OleDbÁ¬½Óoracle 10G´íÎó
¿ª·¢¹¤¾ßÊÇC#£¬Ð´µÄC/SģʽµÄ³ÌÐòʹÓÃORACLE OleDbµÄ·½Ê½Á¬½Óoracle 10GÊý¾Ý¿â£¬Õý³£²Ù×÷ûÎÊÌ⣬ֻҪһ·ÖÖÓ²»²Ù×÷£¬È»ºóÓ¦ÓóÌÐò¼ÌÐø¶ÔÊý¾Ý¿â²Ù×÷¾Í»á±¨³ö¡°Ã»ÓпÉÓõĴíÎóÐÅÏ¢£¬´íÎó´úÂ룺E_FAIL(0x80004005)¡±£¬ÊDz»ÊÇoracleÀïÓÐʲô²ÎÊýÒªÉèÖ᣻òÕ߿ͻ§¶ËʹÓÃORACLE OleDÁ¬½ÓÊý¾Ý¿âʱÓÐʲôÏÞÖÆ¡£
Èç¹ûÓÃsqlplusµÇ¼oracle£¬³¬¹ý1·ÖÖÓ²»²Ù×÷£¬»áÓÐÕâÑùµÄÇé¿öÂð
Ïà¹ØÎÊ´ð£º
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 ......
×Ö¶Î FORGANGUID TOTAL FSTATETYPE
1 0412105DA35645EA9A32AE160EEA25BF 1;1 estIllnessRest;estRetire
2 05AF08C3195B4075847685E96711457D 1 estRegular
3 10EDE82520F24289B7 ......
ÎÊÌâÃèÊö£º
1¡¢¼ÙÉèÓбí
t1±í£¬°üº¬ËÄÁÐ
s1 a b c
1 a a a
2 b b b
.........
t2±í£¬°üº¬2ÁÐ
s2 ff
1 77
2 88
............
ÈçºÎÉú³ÉÕâÑùµÄºÏ²¢Ê ......
Çë¸÷λ¸ßÊÖ°ïæ oracleºº×ÖתƴÒô
±ÈÈçÏÖÔÚÓиöÁÐ ÀïÃæµÄºº×ÖΪÄãºÃ ÎÒÏë²é³öÀ´µÄÊÇN ÇëÎʸ÷λ¸ßÊÖÈçºÎʵÏÖ ¸ø¸öÏêϸµÄ¿´¿´ лÁË
ÓÐÖªµÀµÄ¸æËßÒ»Éù ллÁË
ûÕÒµ½°¡ Äܸø·¢Ò»¸öÂð
ÄÄλ˧¸çÄܸøÏêϸµÄËµÒ ......