Oracle²¢·¢ÎÊÌâ
ÔõÑùʹÓÃËø»úÖÆ¿ØÖÆÁ½¸öÓû§²»ÄÜͬʱ¶ÔÒ»ÕűíÖÐÒ»ÌõÏàͬµÄ¼Ç¼½øÐÐÐ޸IJÙ×÷£¿
ORACLE»á×Ô¶¯ÌæÄã¿ØÖÆµÄѽ
Ä㻹ÏëÔõô¿ØÖÆ ºÇºÇ
Oracle ×Ô¼º»á¹ÜÀíÕâЩ¡£ÎÒÃÇÖ»ÐèҪʹÓÃSQLÃüÁî¾Í¿ÉÒÔÁË¡£¡£
------------------------------------------------------------------------------
Blog£º http://blog.csdn.net/tianlesoftware
ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net
Ïà¹ØÊÓÆµ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q Ⱥ£º62697716
oracle±¾À´¾Í»á¼ÓÐм¶ËøµÄ¡£¡£¡£
oracleµÄTMËø¡¢TXËøÖªÊ¶ÍêÈ«ÆÕ¼°
http://blog.csdn.net/crazylaa/archive/2009/12/08/4966787.aspx
ÔÚϳ¢ÊÔÁËÏ£¬²»Í¬µÄÓû§¿ÉÒÔ¶Ôͬһ±íÖеÄͬһÌõÊý¾Ý¸üУ¬
¶øÇÒÊÇÔÚ×Ô¶¯Ìá½»ÉèÖóÉoffµÄÇé¿öÏÂ
µÈ´ýÖÐ~
àÞ£¿ÒòΪcommitÉèÖóÉoffÁË£¬ÉèÖóÉon£¬¿´Ò»¸ö²»commit£¬ÁíÒ»¸ö»á²»»áÒ»Ö±µÈ´ý¡£
ÁíÍ⣬¿´µ½µÄ²»´ú±í³É¹¦ÁË¡£A update£¬B update£¬A select ¿´¿´B updateµÄÓÐûÓгöÀ´£¿
Ïà¹ØÎÊ´ð£º
±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......
abnormal end of export file
IMP-00028: partial import of previous table rolled back: 3828 rows rolled back
ÓÐûÓÐÒ»ÖÖ·½·¨Èõ¼Èë¼ÌÐø½øÐжø²»Òì³£Ìø³ö»Ø¹ö£¿
ignore=y
Äã² ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ
ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......