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

oracleºÏ²¢±íµÄË鯬

Shrink spaceºÏ²¢±íµÄË鯬
Ò»°ã±íÀïÓÐË鯬ÎÒÃǶ¼²ÉÓÃalter table table_name move tablespace_name,»òÕßexp,drop table table_name,impµÄ2ÖÖ·½Ê½10G¸øÎÒÃÇÆäËûµÄ·½·¨.ÏÂÃæÎÒÀ´ÊÔÒ»°É
ÓÃShrink SpaceÊÕËõOracleÊý¾Ý¶Î
ÔÚoracleÖпÉÒÔʹÓÃalter table table_name shrink spaceÊÕËõ±í,ʹÓÃshrinkÓÐÁ½¸öǰÌáÌõ¼þ:
  1¡¢±í±ØÐëÆôÓÃrow movement
  2¡¢±í¶ÎËùÔÚ±í¿Õ¼äµÄ¶Î¿Õ¼ä¹ÜÀí(segment space management)±ØÐëΪauto
ʵÑéÈçÏ£º
--½¨Á¢Ò»¸ösegment space management auto±í¿Õ¼ä
SQL> create tablespace ts_auto datafile 'd:\oracle\product\10.2.0\oradata\orcl\ts_auto.dbf' size 100m
 extent management local segment space management auto;
±í¿Õ¼äÒÑ´´½¨¡£
--½¨Òé²âÊÔ±í
SQL> create table  table_auto  as select * from dba_objects;
±íÒÑ´´½¨¡£
--²é¿´shrinkǰµÄ¿éÊýÁ¿
SQL> select blocks from dba_segments where segment_name='table_auto';
    BLOCKS                                                                    
----------                                                                    
       768                                           &nbs


Ïà¹ØÎĵµ£º

Oracle¶àÐмǼºÏ²¢/Á¬½Ó/¾ÛºÏ×Ö·û´®µÄ¼¸ÖÖ·½·¨

ʲôÊǺϲ¢¶àÐÐ×Ö·û´®£¨Á¬½Ó×Ö·û´®£©ÄØ£¬ÀýÈ磺
SQL> desc test;
Name     Type          Nullable Default Comments
------- ------------ -------- ------- --------
COUNTRY VARCHAR2(20) Y       &nb ......

oracleËéÆ¬Ð¡½á

author£ºskate
time£º2010-05-31
ÎÒÃÇÔÚʹÓÃwindowsµÄʱºò£¬¶¼ÖªµÀÒª¶¨ÆÚÕûÀí´ÅÅÌË鯬£¬ÒòΪ´ÅÅÌË鯬»áÓ°ÏìÐÔÄÜ£¬¸ø¹ÜÀíÉÏ´øÀ´¶îÍâµÄ
¸ºµ£¡£ÄÇoracle¸üÊÇÈç´Ë£¬µ±Ëæ×ÅÊý¾ÝÔö¼Ó£¬oracle´¦Àíº£Á¿Êý¾Ý±¾Éí¾ÍÒѾ­ºÜ·ÑÁ¦Á˰¡£¬Èç¹ûÔÙÓдóÁ¿
µÄË鯬£¬ÄǾÍÊÇÑ©ÉϼÓ˪°¡¡£ËùÒÔËéÆ¬ÒªÒýÆðdbaµÄ¸ß¶ÈÖØÊÓ£¬¾¡Ôç·¢ÏÖ¾¡Ôç´¦Àí¡£
莮 ......

Oracle±í¿Õ¼äµÄ½¨Á¢

CREATE TABLESPACE mySpace
datafile
'd:\data\data1.dbf' size 1M reuse
autoextend on next 100k maxsize 2M
'd:\data\data2.dbf' size 1M reuse
online
permanent;
ÆäÖÐonline±íÁª»ú¡£
Áª»úºÍÍÑ»úµÄÇø±ðºÍʹÓÃ
Áª»ú£º ORACLE·þÎñ½ø³Ì¹ØÁªÎļþ¡£¿É¹©oracle¿Í»§¶Ë·ÃÎÊ.Èç¹ûÔÚϵͳÖÐÖ±½Óɾ³ýʱ»áµ¯³öÒì³£¡£
ÍÑ»ú: ......

OracleÊý¾Ý¿éË𻵻ָ´×ܽá(תÌû)

²é¿´Êý¾Ý»µ¿éËùÔÚÊý¾ÝÎļþºÅ¼°¿éºÅ¿ÉÒÔ¶Ô±í½øÐÐÒ»´ÎÈ«±íɨÃ裬È磺
¡¡¡¡select count(*) from tablename;
¡¡¡¡1¡¢Ã»Óб¸·ÝµÄÇé¿öÏ£º
¡¡¡¡1.1¡¢Ê¹ÓÃexp/imp»Ö¸´
¡¡¡¡ÔÚÕâÖÖÇé¿öÏ¿϶¨»áÔì³ÉÊý¾ÝµÄ¶ªÊ§£¬ÔÚÕâÖÖÇé¿öÏÂÓ¦²ÉÈ¡½«Êý¾Ýµ¼³öÈ»ºóÖØ½¨±íÔÙ½øÐе¼ÈëµÄ·½·¨£¬À´¾¡Á¿»Ö¸´Ëð»µÊý¾Ý¿éÖеÄÊý¾Ý£¬µ«ÊÇÔÚÓлµ¿éµÄÇé¿öÏÂ
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ