Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

oracleɾ³ý±íÖÐËùÓеÄÊý¾Ý

ʾÀýÒ»£ºdelete from emp;
ʵÀý¶þ£ºtruncate table emp;
µ±Ê¹ÓÃdeleteɾ³ýʱ£¬ËäȻɾ³ýÁ˱íÖеÄËùÓÐÊý¾Ý£¬µ«ÊÇûÓÐÊͷűíËùÕ¼µÄ¿Õ¼ä£¬Èç¹ûÓû§È·¶¨ÒªÉ¾³ý±íÖÐËùÓÐÊý¾Ý£¬Ê¹ÓÃʵÀý¶þÓï¾äËٶȸü¿ì¡£deleteÓï¾ä¿ÉÒÔ»ØÍË£¬µ«truncateÓï¾ä²Ù×÷²»ÄÜ»ØÍË£¬Ö´ÐеÄʱºòÒª¶à¼Ó×¢ÒâÕâÒ»µã¡£


Ïà¹ØÎĵµ£º

ORACLEÎﻯÊÓͼ ¶¨Î»µ¼ÖÂÎﻯÊÓͼÎÞ·¨¿ìËÙˢеÄÔ­Òò


ÎﻯÊÓͼµÄ¿ìËÙˢвÉÓÃÁËÔöÁ¿µÄ»úÖÆ£¬ÔÚË¢ÐÂʱ£¬Ö»Õë¶Ô»ù±íÉÏ·¢Éú±ä»¯µÄÊý¾Ý½øÐÐˢС£Òò´Ë¿ìËÙË¢ÐÂÊÇÎﻯÊÓͼˢз½Ê½µÄÊ×Ñ¡¡£
µ«ÊÇ¿ìËÙˢоßÓн϶àµÄÔ¼Êø£¬¶øÇÒ¶ÔÓÚ²ÉÓÃON COMMITģʽ½øÐпìËÙˢеÄÎﻯÊÓͼ¸üÊÇÈç´Ë¡£¶ÔÓÚ°üº¬¾Û¼¯ºÍ°üº¬Á¬½ÓµÄÎﻯÊÓͼµÄ¿ìËÙˢлúÖÆ²¢²»Ïàͬ£¬¶øÇÒ¶ÔÓÚ¶à²ãǶÌ×µÄÎﻯÊÓͼµÄ¿ìËÙˢР......

ÓëoracleÊý¾Ý¿âÁ¬½ÓÎÊÌâ

       Èç¹û²»ÊÇÒòΪÕâ´Î»»hisµÄ·þÎñÆ÷£¬¹À¼ÆÎÒÒ»Ö±Ò²²»»áÓöµ½Õâ¸öÎÊÌ⣬һֱ¾õµÃoracleºÜ¸ßÉ¶ÔËüҲûÓÐÑо¿£¬¿ÉÕâ´Î»»·þÎñÆ÷£¬Æ«Æ«ÈÃÎÒÓöµ½ÁËÒ»¸öÎÊÌ⣬ÕÛÄ¥ÁËÕûÕûÁ½Ì죬ÖÕÓÚÔÚ×òÌì½â¾öµôÁË£¬¼Ç¼ÏÂÀ´£¬ÒÔ±¸ÒÔºóËùÓá£
    ÖÜÎåÍíÉÏ»»ÁË·þÎñÆ÷£¬ÖÜÒ»ÔçÉÏ·¢ÏÖ³¬ÉùµÄ¹¤×÷Õ ......

OracleÖÐɾ³ý°üº¬ÎﻯÊÓͼµÄ±í¿Õ¼äµÄ·½·¨


½ñÌìɾ³ýµÄ±í¿Õ¼ä°üº¬ÎﻯÊÓͼ±¨´í£¬ORA-23515: ʵÌ廯ÊÓͼºÍ/»òËüÃǵÄË÷Òý´æÔÚÓÚ±í¿Õ¼äÖÐ
¿´À´ÊÇÐèҪɾ³ýÎﻯÊÓͼ£¬Ö´ÐÐɾ³ý²Ù×÷£¬ÒòΪÊý¾ÝÌ«´óÁË£¬°ëÌìҲûŪÍ꣬ȡÏûÁË£¬ÉÏÍø²éÁíÍâÒ»ÖÖ·½·¨£¬É¾³ýÓû§£¬Ö¸¶¨cascade ²ÎÊý£¬ÕâÑù¾Í¿ÉÒÔÁË
ÎÒÊÔÁËһϸоõÓÃ
drop user user_name cascade;
ɾ³ýµÄ»¹ÊÇͦ¿ìµÄ£¬±Èɾ³ýÎï ......

C# µ÷ÓÃOracle ´æ´¢¹ý³Ì·µ»ØÊý¾Ý¼¯ ʵÀý

1. ÔÚoracle Ï´´½¨±í
     t_user(
        ID varchar(20),
        Name varchar(20)
       )
 2.  Ìí¼ÓÊý¾Ý 
         &nb ......

µ±ORACLE¹éµµÈÕÖ¾ÂúºóÈçºÎÕýȷɾ³ý¹éµµÈÕÖ¾

µ±ORACLE ¹éµµÈÕÖ¾ÂúÁ˺󣬽«ÎÞ·¨Õý³£µÇÈëORACLE£¬ÐèҪɾ³ýÒ»²¿·Ö¹éµµÈÕÖ¾²ÅÄÜÕý³£µÇÈëORACLE¡£
Ò»¡¢Ê×ÏÈɾ³ý¹éµµÈÕÖ¾ÎïÀíÎļþ£¬¹éµµÈÕÖ¾Ò»°ã¶¼ÊÇλÓÚarchiveĿ¼Ï£¬AIXϵͳÏÂÎļþ¸ñʽΪ“1_17884_667758186.dbf”£¬½¨Òé²Ù×÷ǰÏȶÔÊý¾Ý¿â½øÐб¸·Ý£¬É¾³ýʱÖÁÉÙ±£Áô×î½ü¼¸ÌìµÄÈÕÖ¾ÓÃÓÚÊý¾Ý¿â»Ö¸´¡£
¶þ¡¢°Ñ¹éµµÈÕ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ