Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ±í¿Õ¼ä²Ù×÷

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

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

oracleµ¥Ðк¯Êý

µ¥Ðк¯Êý:
º¯ÊýÀà±ð:
    µ¥ÐÐ:·µ»Øµ¥¸ö½á¹û:substr,length
    ¶àÐÐ:·µ»Ø¶à¸ö½á¹û,any,all
µ¥ÐеķÖÀà:
    ×Ö·ûÀ࣬ÈÕÆÚÀ࣬Êý×ÖÀ࣬ת»»À࣬ͨÓÃÀà
1.×Ö·ûÀà
ת»»´óСд:
lower:ת»»ÎªÐ¡Ð´
Select ENAME,LOWER(ENAME) from EMP
upper:ת»»Îª´óд
Select upper( ......

Oracle£ºÒ»¸öIT¡°Èںϡ±¾ÞÍ·µÄµ®Éú

 10ÔÂ10ÈÕµÄÃÀ¹ú¾É½ðɽһÏÂÓ¿ÈëÁË4ÍòÈËÁ÷£¬ËûÃǾۼ¯ÔھɽðɽµÄMoscone»áÕ¹ÖÐÐÄ£¬ÖÜΧ81000¸ö¾Æµê´²Î»±»¶©¹ºÒ»¿Õ£¬¾É½ðɽÊÐÕþ¸®×¨ÃÅ·âËøÁËÖܱßÈýÌõµÀ·µÄ½»Í¨£¬ÒÔΪÕâЩÅÓ´óÈËÁ÷Ìṩ±ãÀû¡£ÕâЩÈ˶¼ÊÇÈ«ÇòITÒµ½çµÄ¾«Ó¢——´ÓIT¾ÞÍ·µÄÁìÐäµ½ÆÕͨµÄÆóÒµIT¼¼ÊõÈËÔ±£¬´Ó×Éѯ»ú¹¹µÄ·ÖÎöÈËÊ¿µ½¸÷ÐÐÒµµÄÐÅÏ¢»¯Ö÷¹Ü£¬µ ......

ORACLE ʹÓÃDBMS_METADATA.GET_DDL»ñÈ¡DDLÓï¾ä

Oracle ÔÚ9iÒԺ󣬿ÉÒÔÀûÓÃDBMS_METADATA.GET_DDL°üµÃµ½Êý¾Ý¿âµÄ¶ÔÏóµÄddl½Å±¾¡£ÈçÏ£¨SQLPLUSÖÐÖ´ÐУ©£º
1. »ñÈ¡µ¥¸öµÄ½¨±í¡¢ÊÓͼºÍ½¨Ë÷ÒýµÄÓï·¨
set pagesize 0
set long 90000
set feedback off
set echo off
spool DEPT.sql
select dbms_metadata. ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ