Á´½Óµ½Í¬Ò»¸öÊý¾Ý¿â£¬ÎªÊ²Ã´²»Í¬Óû§¿´µ½µÄ±í²»Ò»Ñù£¿
ÔÚÓû§user1Ï´´½¨±íTable1£¬ÎªÊ²Ã´ÔÚÓû§user2Ï¿´²»µ½Table£¿
OracleϵÄÓû§µ½µ×ÊǸöʲô¸ÅÄî°¡£¿
ÒÔǰÊÇÓÃSQL ServerµÄ£¬ËùÓеÄÓû§£¬Ö»ÒªÁ´½Óµ½Í¬Ò»¸öÊý¾Ý¿â£¬¿´µ½µÄÊý¾Ý¿â¶ÔÏó¶¼ÊÇÒ»ÑùµÄ°¡¡£
¾´ÇëÏê½â¡£
oracleÊÇÒ»¸ö¶àÓû§µÄ²Ù×÷Ï ......
ÈçÌ⣺sqlµ÷Õû×î¹Ø×¢µÄÊÇʲô£¿
µ±ÃæÊÔ¹ÙÕâÑùÎÊÎÒʱ£¬ÎÒÔõô»Ø´ð²Å¹»×¨Òµ£¿£¿£¿£¿Ï£ÍûµÃµ½×¨Òµ¡¢ÕýÈ·µÄ»Ø´ð£¡£¡
ÐÔÄÜ£¿Ï¹²Â£¬ºÇºÇ¡£
¹Ø×¢Ö´Ðмƻ® ,±ØÐë×ßindex seekµÄʱºò¾ø²»×ßscan, ˵µ½µ×ÁË ¾ÍÊÇÓÃ×îÉÙµÄ×ÊÔ´×ö×î¶àµÄÊÂ,
²¢ÇÒ°ÑÓ¦Óõĵ±Ç°»·¾³¿¼ÂǽøÀ´,Æ©Èç~ lockÁ£¶ÈµÄÑ¡Ôñ...²¢·¢µÄÁ¿ ,tableµÄÉè¼Æ..
......
ͨ¹ýodbcÿ´ÎÖ»Äܵ¼³öÒ»¸ö±í£¬Óкΰ취½«200¶à¸ö±íÈ«²¿Ò»´Îµ¼³ö
ÒýÓÃ
ÒýÓÃÂ¥Ö÷ gzluoy µÄ»Ø¸´:
ͨ¹ýodbcÿ´ÎÖ»Äܵ¼³öÒ»¸ö±í£¬Óкΰ취½«200¶à¸ö±íÈ«²¿Ò»´Îµ¼³ö
Õâ¸ö¿ÉÄÜÐèÒªµÚÈý·½¹¤¾ß.
ÀýÈçPBµÄÊý¾Ý¹ÜµÀ.
SQL SERVERµÄDTS.
Êý¾Ý¹ÜµÀÒ»´ÎÖ»Äܵ¼ÈëÒ»¸öÎļþ£¬dtsµ¼ÈëʱÌáʾoracleÓû§²»´æÔÚ
......
ÎÒÓÃVC2005¿ª·¢Ò»¸öÁ¬½ÓOracleÊý¾Ý¿âµÄ³ÌÐò,Ϊʲô×ÜÊÇÁ¬½Ó²»ÉÏ?
1."Driver={Oracle in instantclient10_2};Data Source=DBName"
ÓÃÉÏÃæÕâ¸öÁ¬½Ó´®,ÎÒ°²×°ÁËOra10InstantClient,¿ÉÒÔÁ¬½Ó,µ«±ØÐëÒªÅäÖÃODBCÊý¾ÝÔ´Ãû(DBName),ÎÒ²»Ïëÿ´Î¶¼ÅäÖÃ,Ó¦¸ÃÔõô°ì?
2.""Provider=OraOLEDB.Oracle;Data S ......
ÌáʾoracleÖеÄÓû§²»´æÔÚ£¬¿ÉÎÒÒѾ½¨ºÃÓû§ÁË£¬¶øÇÒÔÚsql plus ÖпÉÒÔ½øÐн¨±íµÄ²Ù×÷¡£
ÎÒÔÚѡĿµÄÊý¾ÝԴʱѡÔñµÄÊÇoracle in orahome92
ÎÒµÄÐèÇóºÍÀÏ´óµÄ¿ÉÄÜÓеã³öÈ룬ÎÒµÄÈÎÎñÊǽ«sql server ÖеÄÊý¾ÝÍêÕûµÄµ¼Èëµ½oracleÖÐ
ÒýÓÃ
ÌáʾoracleÖеÄÓû§²»´æÔÚ£¬¿ÉÎÒÒѾ½¨ºÃÓû§ÁË£¬¶øÇÒÔÚsql plus ÖÐ¿É ......
ÒÔǰһֱÓõÄÊÇSQL SERVER
µ½Á˵¥Î»£¬Êý¾Ý¿âÓõÄÊÇoracle£¬ÍøÉÏ¿´ÁËЩÌû×Ó£¬»¹ÊÇÓÐЩ²»Ã÷²»°×£¬ÄÄλÓÐÏêϸµãµÄ²½ÖèµÄ
¶Ë¿Ú1521 IPÊÇ192.168.0.1¾ÙÀýÈç´Ë£¬ÔõôÁ¬½Ó¡£
Ò»°ãÐèÒªÏȰ²×°oracle¿Í»§¶Ë,¸ù¾ÝÇé¿ö,¿ÉÒÔÑ¡ÔñÐÔµÄ×°oracleµÄodbc/oledbÇý¶¯
Ò» ......