Oracle¿Í»§¶Ë°²×°ºóODBCÎÞ·¨Ê¹ÓÃ
°²×°11gµÄ06,´ò²¹¶¡Éýµ½07£¬´ÓODBCÀïÃæ¿´£¬ÓÐ
Oracle in OraOdac11g_home1 11.01.00.07
´Ó×¢²á±í¿´HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ÏÂÃæµÄDriverºÍSetup¶¼ÊÇÎҵݲװ·¾¶
"D:\\app\\Administrator\\product\\11.1.0\\client_1\\SQORA32.DLL"
½¨ODBCÊý¾ÝÔ´µÄʱºòÄÜ¿´µ½126µÄ´íÎó£º
The setup routines for the Oracle in instantclient11_1 ODBC driver could not be loaded due to system error code 126.
Ó¦ÓóÌÐòÁ¬½ÓÊý¾Ý¿âµÄʱºòÊÇ1114µÄ´íÎó£º
Error Cannot Load Resource File sqresus.dll
ERROR[IM003] Specified driver could not be loaded due to system error 1114 (Oracle in OraOdac11g_home1).
ÎÊÌâÊÇÎÒ3¸öÔÂǰ¾ÍÊÇÓÃͬÑùµÄ°ü°²×°µÄ£¬µ±Ê±Ê²Ã´ÎÊÌⶼûÓС£Õâ´ÎÊÇÁ½Ì¨»úÆ÷ÈÃITµÄÈËÐÂ×°ÁËÁ½Ì¨Ó¢ÎĵÄXP+SP2¡£È»ºóÁ½Ì¨¶¼ÓÐÕâÑùµÄÎÊÌâ¡£ºóÀ´´ÓÍøÉÏÏÂÁËÒ»¸ö×îеÄODBCÇý¶¯£¬¿´°üÀïÃæµÄDLLÎļþµÄÈÕÆÚºÍ³ß´ç£¬ºÍÎÒ»úÆ÷ÉϵͼÊÇÒ»ÑùµÄ¡£ºóÀ´»¹ÊÇ×°ÁËÒ»´Î£¬È»ºóODBC¶àÁËÒ»¸öÃûΪOracle in instantclient11_1µÄÏ°æ±¾Ò»Ñù»¹ÊÇ11.01.00.07£¬°²×°ºóÖØÆô£¬ÎÊÌâÕվɡ£
ÄÄλÓöµ½¹ýÀàËÆµÄÎÊÌ⣿ÏÈлÁË¡£
´ó¼Ò°ï°ï濴һϰÉ
{{
Ïà¹ØÎÊ´ð£º
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
¹ØÓÚORACLEÈÏÖ¤¿¼ÊÔ¶¼°üÀ¨ÄÄЩ°¡£¿
СµÜ¶ÔÓÚÕâ¸öÈÏÖ¤²»ÔõôÁ˽⣬Ã÷°×È˸ø½²½²¡£
ÎÒ¾ÍÌý˵¹ýÓÐOCPÈÏ֤ʲôµÄ...
Õâ¸ö²»´í£¬Äã¿ÉÒÔÁ˽âÏÂ
http://www.oracle.com.cn/viewthread.php?tid=4834&extra=pag ......
Oracle µÄ Ô¼ÊøÊÇÊÇ·ñ¿ÉÒÔ¸´Óã¿£¨µ÷ÓÃÔ¼ÊøÃû³Æ¾Í¿ÉÒÔÖ±½ÓʹÓøÃÔ¼Êø£©ÔÚÄÄÀï¿ÉÒÔ¹ÜÀíÔ¼Êø¡£
plsqlÓÐÕâ¸ö¹¦ÄÜô£¿
SQL code:
Ö±½ÓÓÃPL/SQL DEVELOPER µã»÷TABLES ÖÐcheck constraints
ÒýÓÃ
SQL ......
¸ßÊÖ¸ø¸ö´æ´¢¹ý³Ì£¬ÄÜÑ»·²åÈë10ÍòÌõ¼Ç¼£»ÔÚÏߵȡ£¡£¡£
Ñ»·²åÈë10ÍòÌõ¼Ç¼£¿ÄܾßÌåµãÂð
ûÃ÷°×
SQL code:
--Á½±íÈç¹ûÒ»ÖÂʱ£º
insert into tableA as select * from tableB;
ÕâÎÊÌâÎʵÄ
ÎÞÃûÀÏ× ......
Ê×ÏÈ˵˵±¾ÈËÏë·¨
±¾ÈËÏëÒÔһֱѧϰoracleÊý¾Ý¿â²¢ÇÒÂýÂýµÄÉîÈëÏÂÈ¥,ËùÒÔ¾ÍÉæ¼°µ½Ê¹ÓõÄÎÊÌâµÄ,ÒòΪʹÓõĻú»áÔ½¶àËùÒÔѧÆðÀ´Ó¦¸ÃÔ½¿ì.
ËùÒÔÎÒÏëÒÔºóÔÚÏîÄ¿Öж¼Ê¹ÓÃ,ÄÇô¾Í»áÉæ¼°µ½ÊÕ·ÑÎÊÌâ,
±ÈÈç˵ÎÒÃǹ«Ë ......