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

OracleÊý¾Ý¿â½µµÍHWMµÄ¼¸ÖÖ·½·¨

HWMÊÇoracleÖÐblockÓÐûÓÐʹÓõķֽçÏߣ¬Ëü»áËæ×ÅÊý¾ÝµÄinsert¶øÉÏÉý£¬µ«Ëü²¢²»»áËæÊý¾ÝµÄdelete¶øÏ½µ£¬Òò´ËÈ«±íɨÃèµÄʱ¼ä²¢²»ÒòÊý¾ÝµÄdelete¶ø¼õÉÙ£¬Ïà·´¿ÉÄÜÓÉÓÚ¿éÇå³ý·´¶øÈ«±íɨÃèʱ¼äÔö¼Ó£¬¿ÉÒÔÓÃÏÂÃæ·½·¨µÄÈÎÒ»Ò»ÖÖÀ´½µµÍHWM£º
µÚÒ»ÖÖ£ºshrink
ÊÊÓÃÓÚ10gÒÔºóµÄ°æ±¾£¬Ç°ÌáÊÇÕâ¸ö±í£¬Ë÷Òý£¬ÎﻯÊÓͼ»òÎﻯÊÓͼlogËùÔÚ±í¿Õ¼äsegmentµÄ¹ÜÀíÊÇautoµÄ£¬²¢ÇÒ±íÒÑenable row movement£¬È磺
SQL> select owner,segment_name,bytes,blocks,extents from dba_segments
where segment_name = 'EMP';
SQL> alter table emp enable row movement;
SQL> alter table emp shrink space;
SQL> select owner,segment_name,bytes,blocks,extents from dba_segments
where segment_name = 'EMP';
µÚ¶þÖÖ£ºonline redefinition
online redefinitionÔÚoracle 9iÒýÓã¬10g¶ÔDBMS_REDEFINITION°ü×öÁËһЩµ÷Õû£¬Ê¹ÓõIJÙ×÷ÆðÀ´Àí¼òµ¥£¬ÈçÐÂÔö¼ÓµÄCOPY_TABLE_DEPENDENTS£¬UNREGISTER_DEPENDENT_OBJECT£¬·½·¨ÈçÏ£º
1.µ÷ÓÃdbms_redefinition.can_redef_table procedureÈ·ÈÏÊÇ·ñ¿ÉÒÔonline redefinition
SQL> EXECUTE dbms_redefinition.can_redef_table ('FINANCE', 'ACCTS_PAYABLE');
2.ÔÚredefinition schemaÏ´´½¨interim table
3.Èç¹ûredefinitionÒ»¸ö´ó±í£¬¿ÉÒÔÓÃÏÂÃæµÄStatementÀ´¸ÄÉÆÐÔÄÜ:
SQL> alter session force parallel dml parallel degree-of-parallelism;
SQL> alter session force parallel query parallel degree-of-parallelism;
4.µ÷ÓÃdbms_redefinition.start_redef_table procedure¿ªÈçredefinition
SQL> dbms_redefinition.start_redef_table('FINANCE', 'ACCTS_PAYABLE','ACCTS_PAYABLE_STAGE');
5.´´½¨dependent objects on interim table
ÓÐÁ½ÖÖ·½·¨£º
µ÷ÓÃdbms_redefinition.copy_table_dependents×Ô¶¯´´½¨dependent objects;
ʹÓÃcreate statementÊÖ¶¯´´½¨dependent objects£¬ÊÖ¶¯´´½¨µÄdependentsÐèÒªµ÷ÓÃregister_dependent_object×¢²á
6.¸üÐÂÔÚredefinition¹ý³ÌÖеĸüе½interim±í
7.µ÷ÓÃdbms_redefinition.finish_redef_tableÍê³Éredefinition
8.ɾ³ýÊջؿռäÈçinterim tableʹÓõıí
×¢£ºÊ¹ÓÃonline redefinitionÐèÒª¶îÍâµÄ¿Õ¼ä
µÚÈýÖÖ£ºalter table … move
ÔÚmoveʱ¿ÉÒÔʹÓõ±Ç°±í¿Õ¼äÒ²¿ÉÒÔÖ¸¶¨ÆäËû±í¿Õ¼ä£¬È磺
SQL> alter table emp move;    


Ïà¹ØÎĵµ£º

OracleϵÁУº¼Ç¼Record

 OracleϵÁУº¼Ç¼£¨Record£©
Ò»£¬Ê²Ã´ÊǼǼ£¨Record£©£¿
 Óɵ¥ÐжàÁеıêÁ¿¹¹³ÉµÄ¸´ºÏ½á¹¹¡£¿ÉÒÔ¿´×öÊÇÒ»ÖÖÓû§×Ô¶¨ÒåÊý¾ÝÀàÐÍ¡£×é³ÉÀàËÆÓÚ¶àάÊý×é¡£
½«Ò»¸ö»ò¶à¸ö±êÁ¿·â×°³ÉÒ»¸ö¶ÔÏó½øÐвÙ×÷¡£ÊÇÒ»ÖÖÁÙʱ¸´ºÏ¶ÔÏóÀàÐÍ¡£
 
 ¼Ç¼¿ÉÒÔÖ±½Ó¸³Öµ¡£RECORD1 :=RECORD2£»
 ¼Ç¼²»¿ÉÒÔÕûÌå±È½Ï. ......

OracleÓû§¹ÜÀí

 Ò»£¬OracleÊý¾Ý¿âÓû§¼ò½é
 ÔÚOracleÊý¾Ý¿âÖÐÈκζÔÏó¶¼ÊôÓÚÒ»¸öÌØ¶¨Óû§£¬»òÕß˵һ¸öÓû§ÓëͬÃûµÄģʽÏà¹ØÁª¡£
 ÒªÁ¬½Óµ½OracleÊý¾Ý¿âÐèÒªÒ»¸öÓû§ÕÊ»§£¬¸ù¾ÝÐèÒªÊÚÓèµÄ²Ù×÷ȨÏÞ¡£
 1£¬Ä¬ÈÏÊý¾Ý¿âÓû§Ä£Ê½£º
  Sys:Êý¾Ý¿â×ֵ䣨´æ´¢±»¹ÜÀí¶ÔÏóËùÓÐÐÅÏ¢£©ºÍÊÓͼ´æ´¢ÔÚ¸ÃģʽÖС£ÏµÍ³¼¶Óû§¡£ ......

¡¾×ª¡¿Oracle Tablespace´´½¨

 Tablespace
ORACLEÖУ¬±í¿Õ¼äÊÇÊý¾Ý¹ÜÀíµÄ»ù±¾·½·¨£¬ËùÓÐÓû§µÄ¶ÔÏóÒª´æ·ÅÔÚ±í¿Õ¼äÖУ¬Ò²¾ÍÊÇÓû§ÓпռäµÄʹÓÃȨ£¬²ÅÄÜ´´½¨Óû§¶ÔÏó£®·ñÔòÊDz»³äÐí´´½¨¶ÔÏó£¬ÒòΪ¾ÍÊÇÏë´´½¨¶ÔÏó,Èç±í,Ë÷ÒýµÈ£¬Ò²Ã»Óеط½´æ·Å,Oracle»áÌáʾ:ûÓд洢Åä¶î£®
¡¡¡¡Òò´Ë£¬ÔÚ´´½¨¶ÔÏó֮ǰ£¬Ê×ÏÈÒª·ÖÅä´æ´¢¿Õ¼ä£®¡¡¡¡
  ·ÖÅä´æ ......

oracle Ìåϵ½á¹¹

ǰ¼¸ÌìÃæÊÔµÄʱºòÃæÊÔ¹Ù²ÅÎʹýÎÒORACLEµÄÌåϵ½á¹¹£¬ÈÃÎÒÔÚÒ»ÕŰ×Ö½ÉÏ»­³öÀ´¡£»ØÍ·ÏëÏ뵱ʱ´ðµÃ»¹²»´í£¬´ó²¿·ÖÄÚÈݶ¼ÃèÊö³öÀ´ÁË£¬ºÇºÇ£¬¸Õ²ÅÔÚÍøÉÏ¿´µ½Ò»Æª½²½âORACLEÌåϵ½á¹¹µÄÎÄÕ£¬¾õµÃ²»´í£¬×ª¹ýÀ´´æ×Å£¬½«À´¿ÉÄÜ»áÓõ½¡£
=================================================================================
ÔÚ±¾ÎÄÀ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ