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

Oracle Shrink Table

½ñÌìÔÚ´÷Ã÷Ã÷ͬѧµÄÒ»¸ö»ØÌûÀï¸øÁ˸ö¹ØÓÚShrinkÃüÁîµÄÌû×Ó£¬×ª¹ýÀ´Ñ§Ï°Ñ§Ï°~
=============================================================================================
´Ó10g¿ªÊ¼£¬oracle¿ªÊ¼ÌṩShrinkµÄÃüÁ¼ÙÈçÎÒÃǵıí¿Õ¼äÖÐÖ§³Ö×Ô¶¯¶Î¿Õ¼ä¹ÜÀí (ASSM),¾Í¿ÉÒÔʹÓÃÕâ¸öÌØÐÔËõС¶Î£¬¼´½µµÍHWM¡£ÕâÀïÐèҪǿµ÷Ò»µã£¬10gµÄÕâ¸öÐÂÌØÐÔ£¬½ö¶ÔASSM±í¿Õ¼äÓÐЧ£¬·ñÔò»á±¨ ORA-10635: Invalid segment or tablespace type¡£
 
Èç¹û¾­³£ÔÚ±íÉÏÖ´ÐÐDML²Ù×÷£¬»áÔì³ÉÊý¾Ý¿â¿éÖÐÊý¾Ý·Ö²¼Ï¡Ê裬ÀË·Ñ´óÁ¿¿Õ¼ä¡£Í¬Ê±Ò²»áÓ°ÏìÈ«±íɨÃèµÄÐÔÄÜ£¬ÒòΪȫ±íɨÃèÐèÒª·ÃÎʸü¶àµÄÊý¾Ý¿é¡£´Óoracle10g¿ªÊ¼£¬±í¿ÉÒÔͨ¹ýshrinkÀ´ÖØ×éÊý¾ÝʹÊý¾Ý·Ö²¼¸ü½ôÃÜ£¬Í¬Ê±½µµÍHWMÊÍ·Å¿ÕÏÐÊý¾Ý¿é¡£
 
segment shrink·ÖΪÁ½¸ö½×¶Î£º
 
1¡¢Êý¾ÝÖØ×é(compact):ͨ¹ýһϵÁÐinsert¡¢delete²Ù×÷£¬½«Êý¾Ý¾¡Á¿ÅÅÁÐÔڶεÄÇ°Ãæ¡£ÔÚÕâ¸ö¹ý³ÌÖÐÐèÒªÔÚ±íÉϼÓRXËø£¬¼´Ö»ÔÚÐèÒªÒÆ¶¯µÄÐÐÉϼÓËø¡£ÓÉÓÚÉæ¼°µ½rowidµÄ¸Ä±ä£¬ÐèÒªenable row movement.ͬʱҪdisable»ùÓÚrowidµÄtrigger.ÕâÒ»¹ý³Ì¶ÔÒµÎñÓ°Ïì±È½ÏС¡£
 
2¡¢HWMµ÷Õû£ºµÚ¶þ½×¶ÎÊǵ÷ÕûHWMλÖã¬ÊÍ·Å¿ÕÏÐÊý¾Ý¿é¡£´Ë¹ý³ÌÐèÒªÔÚ±íÉϼÓXËø£¬»áÔì³É±íÉϵÄËùÓÐDMLÓï¾ä×èÈû¡£ÔÚÒµÎñÌØ±ð·±Ã¦µÄϵͳÉÏ¿ÉÄÜÔì³É±È½Ï´óµÄÓ°Ïì¡£
 
shrink spaceÓï¾äÁ½¸ö½×¶Î¶¼Ö´ÐС£
 
shrink space compactÖ»Ö´ÐеÚÒ»¸ö½×¶Î¡£
Èç¹ûϵͳҵÎñ±È½Ï·±Ã¦£¬¿ÉÒÔÏÈÖ´ÐÐshrink space compactÖØ×éÊý¾Ý,È»ºóÔÚÒµÎñ²»Ã¦µÄʱºòÔÙÖ´ÐÐshrink space½µµÍHWMÊÍ·Å¿ÕÏÐÊý¾Ý¿é¡£
 
shrink±ØÐ뿪ÆôÐÐÇ¨ÒÆ¹¦ÄÜ¡£
 
alter table table_name enable row movement ;
 
×¢Ò⣺alter table XXX enable row movementÓï¾ä»áÔì³ÉÒýÓñíXXXµÄ¶ÔÏó(Èç´æ´¢¹ý³Ì¡¢°ü¡¢ÊÓͼµÈ)±äΪÎÞЧ¡£Ö´ÐÐÍê³Éºó£¬×îºÃÖ´ÐÐÒ»ÏÂutlrp.sqlÀ´±àÒëÎÞЧµÄ¶ÔÏó¡£
============================================================================================
utlrp.sql and utlprp.sql
The utlrp.sql and utlprp.sql scripts are provided by Oracle to recompile all invalid objects in the database. They are typically run after major database changes such as upgrades or patches. They are located in the $ORACLE_HOME/rdbms/admin directory and provide a wrapper on the UTL_RECOMP package. The utlrp.sql script simply calls the ut


Ïà¹ØÎĵµ£º

¹ØÓÚoracleËÀËø

 Èç¹û½ö½öÊÇlock£¬ÒÔÏÂÓï¾ä¿ÉÒÔ·¢ÏÖËùÓÐÓû§Ëø  :
SELECT s.username,
       decode(l.type, 'TM', 'TABLE LOCK', 'TX', 'ROW LOCK', NULL) LOCK_LEVEL,
       o.owner,
       o.object_name,
 &n ......

Oracle´æ´¢¹ý³Ì·ÖÒ³

×ªÔØ
from: http://cid-4e5d038451e31a25.spaces.live.com/blog/cns!4E5D038451E31A25!140.entry
create or replace procedure P_QuerySplit(
      sqlscript varchar2,     --±íÃû/SQLÓï¾ä
      pageSize integer,     ......

JAVAʵÏÖOracleÊý¾Ý¿âµÄÊý¾ÝµÄ·ÖÒ³ÏÔʾ

 
×î½üѧÁËservletºÍoracle£¬Ò²¾Í°ÑËûÃǽáºÏÏ£¬×ö¸ö·ÖÒ³µÄÒ³Ãæ³öÀ´¡£ËãÊÇÒ»ÖÖ¸´Ï°°É¡£
1.Ê×ÏÈÊÇoracleµÄ·ÖÒ³ÏÔʾSQLÓï¾ä£º
select * from(select a.*, rownum  rn from (select * from Person) a where  rownum <= MaxN ......

C#±¸·ÝOracle´úÂë

ÏîÄ¿¿ª·¢ÖУ¬ÐèÒªÔ¶³Ì±¸·ÝÊý¾Ý¿â£¬ÒÔÏÂΪC#Ô¶³Ì±¸·ÝÊý¾Ý¿âµÄ´úÂë
 /// <summary>
/// Êý¾Ý¿â±¸·Ý
/// </summary>
/// <param name="fileName">dmpÎļþÃû³Æ</param>
/// <param name="logFileName">logÎļþÃû³Æ</param>
/// <re ......

OracleÊý¾Ý¿âʹÓü°ÃüÃû¹æÔòµÄÏê½â

¹«Ë¾Òѽ¨Á¢µÄ»ò´ý½¨Á¢µÄÍøÕ¾£¬È磺ÖÐÎÄÕ¾£¨CHINA£©£¬¹ú¼ÊÕ¾£¨ALIBABA£©£¬»ªÉÌÕ¾£¨CHINESE£©µÈ¡£
OLPS
Online process system£¬ÔÚÏß´¦Àíϵͳ£¬¼´ÎÒÃǵĻáÔ±¿ÉÒÔä¯ÀÀµÄÍøÕ¾ËùÁ¬½ÓµÄÊý¾Ý¿â£¬Ò²ÊÇÎÒÃÇËù˵µÄǰ̨¡£
BOPS
Back Office process system£¬ºǫ́´¦Àíϵͳ£¬¼´ÎÒÃǵÄÍøÕ¾µÄ·¢²¼ÏµÍ³¡£
BZO
Business Object(?)£¬¹«Ë ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ