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

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

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


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

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


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

linuxÏÂoracleÆô¶¯¹ý³Ì

ÔÚlinuxÏÂÆô¶¯oracle ºÍÔÚwindowsÊÇÓвî±ðµÄ£¬¶ÔÓÚÒ»°ãÔÚwindowsϲÙ×÷ϰ¹ßÈËÓкܶ಻ÊÊÓ¦£¬ËùÒÔÎÒÌØ±ðдÕâÑùÎÄÕ£¬ÒÔ·½±ãÐÂÊÖ½øÐвÙ×÷£¬ÏÂÃæ¾ÍÒ»²½Ò»²½½²½âÆô¶¯¹ý³Ì¡£
1.ͨ¹ýÖÕ¶ËÁ¬½Óµ½linux·þÎñÆ÷,µ±È»ÕâÑùµÄÈí¼þºÜ¶àÀýÈçputty,SecureCRT,²¢ÒÔoracleÓû§½øÐеǼ£¬·ñÔòÆô¶¯oracleʱ»á´íµÄ£¬Ã»ÓÐȨÏÞÆô¶¯.(Ò²¿ÉÓû§root µ ......

Oracleά»¤³£ÓÃSQLÓï¾ä»ã×Ü


¡¡ÈçºÎÔ¶³ÌÅжÏOracleÊý¾Ý¿âµÄ°²×°Æ½Ì¨
¡¡¡¡select * from v$version;
¡¡¡¡²é¿´±í¿Õ¼äµÄʹÓÃÇé¿ö
¡¡¡¡select sum(bytes)/(1024*1024) as free_space,tablespace_name
¡¡¡¡from dba_free_space
¡¡¡¡group by tablespace_name;
¡¡¡¡SELECT A.TABLESPACE_NAME,A.BYTES TOTAL,B.BYTES USED, C.BYTES FREE,
¡¡¡¡(B.BYTE ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ