oracleɾ³ý±íÖÐËùÓеÄÊý¾Ý
ʾÀýÒ»£ºdelete from emp;
ʵÀý¶þ£ºtruncate table emp;
µ±Ê¹ÓÃdeleteɾ³ýʱ£¬ËäȻɾ³ýÁ˱íÖеÄËùÓÐÊý¾Ý£¬µ«ÊÇûÓÐÊͷűíËùÕ¼µÄ¿Õ¼ä£¬Èç¹ûÓû§È·¶¨ÒªÉ¾³ý±íÖÐËùÓÐÊý¾Ý£¬Ê¹ÓÃʵÀý¶þÓï¾äËٶȸü¿ì¡£deleteÓï¾ä¿ÉÒÔ»ØÍË£¬µ«truncateÓï¾ä²Ù×÷²»ÄÜ»ØÍË£¬Ö´ÐеÄʱºòÒª¶à¼Ó×¢ÒâÕâÒ»µã¡£
Ïà¹ØÎĵµ£º
»ù±¾ÒªÇó
win 7µÄ°æ±¾ÊÇÆì½¢°æ£¬oracle 10g£¨Oracle10gµÚ2°æ10.2.0.3-10.2.0.410203vistaw2k8x86productiondb£©Ñ¸À×ÓÐÏÂÔØ
£¨ËÑË÷“oracle 10g vista”£¬760MB£©
¾ßÌå¹ý³Ì
1.ÅäÖÃÒ»¸öÐéÄâµÄIP£ºÔÚ°²×°ORACLE 10gǰϵͳ»á¼ì²â°²×°µÄһЩǰÌáÌõ¼þÊÇ·ñÂú×㣬
ÍùÍù»áÌáʾ˵£º½«Microsoft LoopBack AdapterÅäÖÃΪ ......
ÎﻯÊÓͼµÄ¿ìËÙˢвÉÓÃÁËÔöÁ¿µÄ»úÖÆ£¬ÔÚË¢ÐÂʱ£¬Ö»Õë¶Ô»ù±íÉÏ·¢Éú±ä»¯µÄÊý¾Ý½øÐÐˢС£Òò´Ë¿ìËÙË¢ÐÂÊÇÎﻯÊÓͼˢз½Ê½µÄÊ×Ñ¡¡£
µ«ÊÇ¿ìËÙˢоßÓн϶àµÄÔ¼Êø£¬¶øÇÒ¶ÔÓÚ²ÉÓÃON COMMITģʽ½øÐпìËÙˢеÄÎﻯÊÓͼ¸üÊÇÈç´Ë¡£¶ÔÓÚ°üº¬¾Û¼¯ºÍ°üº¬Á¬½ÓµÄÎﻯÊÓͼµÄ¿ìËÙˢлúÖÆ²¢²»Ïàͬ£¬¶øÇÒ¶ÔÓÚ¶à²ãǶÌ×µÄÎﻯÊÓͼµÄ¿ìËÙˢР......
Èç¹û²»ÊÇÒòΪÕâ´Î»»hisµÄ·þÎñÆ÷£¬¹À¼ÆÎÒÒ»Ö±Ò²²»»áÓöµ½Õâ¸öÎÊÌ⣬һֱ¾õµÃoracleºÜ¸ßÉ¶ÔËüҲûÓÐÑо¿£¬¿ÉÕâ´Î»»·þÎñÆ÷£¬Æ«Æ«ÈÃÎÒÓöµ½ÁËÒ»¸öÎÊÌ⣬ÕÛÄ¥ÁËÕûÕûÁ½Ì죬ÖÕÓÚÔÚ×òÌì½â¾öµôÁË£¬¼Ç¼ÏÂÀ´£¬ÒÔ±¸ÒÔºóËùÓá£
ÖÜÎåÍíÉÏ»»ÁË·þÎñÆ÷£¬ÖÜÒ»ÔçÉÏ·¢ÏÖ³¬ÉùµÄ¹¤×÷Õ ......
SQL> select * from ta;
ID NAME
---------- --------------------
1 gorey
2 gorey2
SQL> select * from tb;
I ......
¸ù¾ÝÓû§µ¼³öÓï¾ä£º
1.Êý¾Ý¿âµ¼³ö
exp system/jade@JADE_166.111.134.26 file=d:\jade.dmp statistics=none
˵Ã÷£º
systeÊÇÓû§Ãû
jadeÊÇÃÜÂë
JADE_166.111.134.26ÊÇSID±êʾ
file=d:\jade.dmp Êǵ¼³öÎļþµÄ·¾¶¼°ÎļþÃû
2.Êý¾Ý¿âµ¼Èë
imp system/jade@JADE_166.111.134.26 file=d:\jade.dmp fromuser=syst ......