C# ÏòoracleÊý¾Ý¿â²åÈë¸üеÄËÙ¶ÈÎÊÌâ
Ïò´ó¼ÒÇë½ÌÒ»¸öÎÊÌâ C# ÏòoracleÊý¾Ý¿â²åÈ룬ÈçºÎÄÜÈ¥Ìá¸ßЧÂÊ£¿£¿£¿ ÎÒÏÖÔÚ²åÈëÊý¾Ý¿âµÄÊÇÿ5Ãë²åÈëºÍ¸üУ¬Ã¿´Î²åÈëºÍ¸üеÄÊýÄ¿´ó¸ÅÓÐ300Ìõ¼Ç¼×óÓÒ£¡£¡²¢ÇÒÊÇÓöàÏß³Ìͬʱȥ²åÈëºÍ¸üРOracleµÄÈÕÖ¾»á²»»áÀÛ»ýÏÂÀ´£¬¶ø»áµ¼Ö²åÈëµÄЧÂʵģ¿ OracleÊDz»ÊÇÓÐÒ»¸ö²¢ÐвåÈëºÍ¸üÐµģ¿£¿£¿ÓеÄÄÇÓ¦¸ÃÔõÑùÈ¥ÉèÖã¿£¿£¿
alter table tablename nologging£» û°ì·¨C#»ùÓÚ.Net²»»á¿ìµÄ¡£ÒýÓà alter table tablename nologging£» ÊDz»ÊÇÿһ¸ö±í½¨Á¢µÄʱºò¶¼Òª¼ÓÕâ¾ä£¿£¿ ¸ù¾ÝÐèҪʹÓÃÒýÓà ¸ù¾ÝÐèҪʹÓà ÎÒ²»Ì«Ã÷°×°¡~~~~ ²åÈëºÍ¸üУ¬ÎÒ¶¼ÊÇÓô洢¹ý³ÌÿһÌõÈ¥²åÈë»ò¸üеÄÒýÓà Åú´¦Àí£¬Í¨¹ýÏß³ÌÖ´ÐС£ ʹÓÃOracleTransaction ºÍÊý¾Ý¿â²Ù×÷Àà ÅóÓÑ£¬ÄãÓоßÌåµÄÀý×ÓÂ𣿣¿£¿£¿ ʱ¼ä³¤ÁË£¬¼Ç¼¶àÁË£¬¿Ï¶¨»á³öÏÖÓ°ÏìËٶȵÄÎÊÌ⣬ЧÂÊÎÊÌâÒª¿¼ÂǵÄÒòËØºÜ¶à£¬³¤ÆÚÀ´¿´³ÌÐòÓ°ÏìµÄÒòËØÒѾºÜСÁË£¬Òª´ÓÊý¾Ý¿â±¾ÉíÀ´ÓÅ»¯µÄ¡£ÒªÔ¤ÆÚһϽ«À´Êý¾ÝÒªÓжà´ó£¬ÄÜ·ñ¶¨ÆÚ±¸·Ý²»³£ÓõÄÊý¾Ý²¢´Óµ±Ç°¿âÖÐɾ³ý£¬»¹ÓÐÓ²¼þµÄÅäÖÃÒ»¶¨Òª¾¡Á¿µÄ¸ßÅäÖÃһЩ¡£ ¶¥ÒýÓà Ïò´ó¼ÒÇë½ÌÒ»¸öÎÊÌâ C# ÏòoracleÊý¾Ý¿â²åÈ룬ÈçºÎÄÜÈ¥Ìá¸ßЧÂÊ£¿£¿£¿ ÎÒÏÖÔÚ²åÈëÊý¾Ý¿âµÄÊÇÿ5Ãë²åÈëºÍ¸üУ¬Ã¿´Î²åÈëºÍ¸üеÄÊýÄ¿´ó¸ÅÓÐ300Ìõ¼Ç¼×óÓÒ£¡£¡²¢ÇÒÊÇÓöàÏß³ÌͬÊ
Ïà¹ØÎÊ´ð£º
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£ ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É л ......
±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼ ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ² SQL code:
......
¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮ ÎÒÉèÖÃÁËÒ»¸öoracle×ֶΣ¬varchar(3000),È»ºó²åÈëÒ»ÌõÊý¾Ý³¤¶È²Å1000,¾Í±¨´íÁË£®È磺net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update Caused ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
Ï뿼¸öocpÈÏÖ¤£¬µ±È»£¬Ò²ÏëºÃºÃѧµã¶«Î÷¡£ ¿ÉÒÔ×ÔѧµÄ£¡ ¸öÈ˾õµÃÖ»ÒªÕÆÎÕÁËÊý¾Ý¿âµÄ»ù±¾ÀíÂÛ£¬Âò²Î¿¼Êé×Ôѧ±È½Ïʵ¼Êµã£¬ ÌØ±ðÊÇÅàѵ̫¹ó²¢ÇÒ²»¿ÉÄÜѧµ½ºÜ¶à¶«Î÷£¡ Êý¾Ý¿âÊǸö³¤ÆÚµÄѧϰ¹ý³Ì£¬Â¥Ö÷¿ÉÒÔÂý ......