Oracle ±íµÄÒÆ¶¯ºÍË÷ÒýµÄÖØ½¨
ÔµÆðÒ»¸ö±í¿Õ¼äÌ«´ó,ɾ³ýÊý¾ÝºóÓÉÓÚÎļþβ±»ÓÃ,ÎÞ·¨resize,´òËã°ÑËùÓбí¿Õ¼äÉϵĶÔÏómoveµ½Ò»¸öÁÙʱ´æ´¢µÄ±í¿Õ¼ä×öÕûÀí¡£
moveÒ»¸ö±íµ½ÁíÍâÒ»¸ö±í¿Õ¼äʱ,Ë÷Òý²»»á¸ú×ÅÒ»Æðmove£¬¶øÇÒ»áʧЧ¡££¨LOBÀàÐÍÀýÍ⣩±ímove£¬ÎÒÃÇ·ÖΪ£º
*ÆÕͨ±ímove
*·ÖÇø±ímove
*LONG,LOB´ó×Ö¶ÎÀàÐÍmoveÀ´½øÐвâÊÔºÍ˵Ã÷¡£
Ë÷ÒýµÄmove£¬ÎÒÃÇͨ¹ýrebuildÀ´ÊµÏÖ
SQL> select * from v$version;
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
PL/SQL Release 9.2.0.6.0 - Production
CORE 9.2.0.6.0 Production
TNS for Solaris: Version 9.2.0.6.0 - Production
NLSRTL Version 9.2.0.6.0 - Production
Ò»£ºmoveÆÕͨ±í¡¢Ë÷Òý»ù±¾Óï·¨£º
alter table tab_name move tablespace tbs_name;
move¹ýµÄÆÕͨ±í£¬ÔÚ²»Óõ½Ê§Ð§µÄË÷ÒýµÄ²Ù×÷Óï¾äÖУ¬Óï¾äÖ´ÐÐÕý³££¬µ«Èç¹û²Ù×÷µÄÓï¾äÓõ½ÁËË÷Òý£¨Ö÷¼üµ±×öΨһË÷Òý£©£¬Ôò´Ëʱ±¨¸æÓõ½
µÄË÷ÒýʧЧ£¬Óï¾äÖ´ÐÐʧ°Ü£¬ÆäËûÈçÍâ¼ü£¬·Ç¿ÕÔ¼Êø£¬È±Ê¡ÖµµÈ²»»áʧЧ¡£
ÎÒÃÇÐèÒªÖØÐ´´½¨Ö÷¼ü»òË÷Òý£¬»ù±¾Ó﷨Ϊ£º
alter index index_name rebuild;
alter index pk_name rebuild;
Èç¹ûÎÒÃÇÐèÒªmoveË÷Òý£¬ÔòʹÓÃrebuildÓï·¨£º
alter index index_name rebuild tablespace tbs_name;
alter index pk_name rebuild tablespace tbs_name;
Ìáʾ£º²éѯ±íËù¾ßÓеÄË÷Òý£¬¿ÉÒÔʹÓÃuser_indexesÊÓͼ£¨Ë÷ÒýºÍÖ÷¼ü¶¼ÔÚÕâ¸öÊÓͼÀï¿ÉÕÒµ½£©¡£
¶þ£ºmove·ÖÇø±í¼°Ë÷ÒýºÍÆÕͨ±íÒ»Ñù£¬Ë÷Òý»áʧЧ£¬Çø±ðµÄ½ö½öÊÇÓï·¨¶øÒÑ¡£
·ÖÇø»ù±¾Óï·¨£ºÌرðÌáÐÑ×¢Ò⣬Èç¹ûÊǵ¥¼¶·ÖÇø£¬ÔòʹÓùؼü×ÖPARTITION£¬Èç¹ûÊǶ༶·ÖÇø£¬ÔòʹÓÃSUBPARTITIONÌæ´úPARTITION¡£Èç¹û·ÖÇø»ò·ÖÇøË÷Òý±È½Ï´ó£¬¿ÉÒÔʹÓò¢ÐÐmove»òrebuild£¬PARALLEL (DEGREE 2);È磺
ALTER TABLE PART_ALARMTEXTDATA move SUBPARTITION ALARMTEXTDATA_050910_ATD01 TABLESPACE users PARALLEL (DEGREE 2);
ALTER INDEX GLOBAL_ALARMTEXTDATA REBUILD tablespace users PARALLEL (DEGREE 2);
ALTER INDEX LOCAL_ALARMTEXTDATA REBUILD SUBPARTITION ALARMTEXTDATA_050910_ATD01 TABLESPACE users PARALLEL (DEGREE 2);
ÒÆ¶¯±íµÄij¸ö·ÖÇø£º
================
ALTER TABLE tab_name move PARTITION partition_name TABLESPACE tbs_name;
ÖØ½¨È«¾ÖË÷Òý£º
================
ALTER INDEX global_index REBUILD;»ò
ALTER INDEX global_index REBUILD tablespace tbs_name;
Ïà¹ØÎĵµ£º
ÔÚoracleÖе±ÎÒÃÇн¨Á˶à¸öÊý¾Ý¿âºó£¬ÔٴεǼʱ£¬ÏµÍ³Ä¬ÈϵÄÊÇ×îºó´´½¨µÄÄǸöÊý¾Ý¿â¡£
ÈçºÎÉèÖÃÎÒÃÇ×Ô¼ºÏëÒªµÄĬÈÏÊý¾Ý¿âÄØ£¿
·½·¨ºÜ¼òµ¥£¬ÎÒÃÇÖ»ÐèÔÚÔËÐд°¿ÚÀïÊäÈëregedit£¬¼´¿É½øÈë×¢²á±í±à¼Æ÷£¬ÔÚHKEY_LOCAL_MACHI ......
ÔÚ Oracle ÖУ¬¶ÔÓÚÒѾ½¨ºÃµÄÖ÷¼ü£¬ÊÇ×Ô¶¯´´½¨Ë÷ÒýµÄ£¬²¢ÇÒË÷ÒýÊÇ´´½¨µ½µ±Ç°µÄ±í¿Õ¼äÖеģ¬Èç¹ûÒª½«Ë÷Òý¸ü»»µ½ÆäËü±í¿Õ¼ä£¬¿ÉÒÔʹÓÃÈçÏµķ½·¨£¬³¬¼òµ¥£º
alter index index_aaa rebuild tablespace newtablespace;
newtablespace ÊÇÐÂÖ¸¶¨µÄ±í¿Õ¼ä¡£ ......
1 Ä¿µÄ
¹æ·¶Êý¾Ý¿â¸÷ÖÖ¶ÔÏóµÄÃüÃû¹æÔò¡£
2 Êý¾Ý¿âÃüÃûÔÔò
2.1 Êý¾ÝÎļþ
Èç¹ûÊý¾Ý¿â²ÉÓÃÎļþϵͳ£¬¶ø²»ÊÇÂãÉ豸£¬Ô¼¶¨ÏÂÁÐÃüÃû¹æÔò£º
1)Êý¾ÝÎļþÒÔ±í¿Õ¼äÃûΪ¿ªÊ¼£¬ÒÔ.dbfΪ½áβ£¬È«²¿²ÉÓÃСдӢÎÄ×Öĸ¼ÓÊý×ÖÃüÃû¡£Èç¸Ã±í¿Õ¼äÓжà¸öÊý¾ÝÎļþ£¬Ôò´ÓµÚ2¸öÊý¾ÝÎļþ¿ªÊ¼£¬ÔÚ±í¿Õ¼äÃûºó¼Ó_¡£
Àý£º¶Ôsystem±í¿Õ¼äµÄÊý ......
ÔÚʵ¼ÊµÄ¹¤×÷»·¾³ÖУ¬Ðí¶àÈËΪÁËÊÊÓ¦¿Í»§µÄ»·¾³£¬×ÜÊÇÐèҪƵ·±¸ü¸ÄIPµØÖ·£¬µ«ÊÇÔÚIPµØÖ·±ä»»ºó£¬Oracle 10g¾Í»á³öÏÖÆô¶¯²»Á˵ÄÏÖÏó¡£ÍøÉÏÏà¹ØÎÊÌâµÄ¼¼ÊõÎÄÕ´ó¶àÊýÊÇÕë¶ÔOracle 9i£¬»òÕßÒÔǰµÄOracle 8iµÄ°æ±¾£¬¶ÔÓëOracle 10gµÄ°æ±¾£¬´ó¶àÖ»ÊǽéÉÜÁË´ó¸Å£¬²¢Ã»Óиø³ö¾ßÌåµÄ²½Öè!±¾ÎÄÖУ¬ÎÒÃǽ«Õë¶ÔÕâÒ»ÎÊÌâ¸ø³ö¾ßÌåµÄ½â¾ö² ......
ORACLE º¯Êý¿ª·¢
1¡¢½¨Á¢º¯ÊýµÄÓï·¨£º
CREATE [OR REPLACE] FUNCTION º¯ÊýÃû
[ (arg1 [mode] datatype[,........])] --µ±Ö¸¶¨²ÎÊýÊý¾ÝÀàÐÍʱ£¬²»ÄÜÖ¸¶¨Æä³¤¶È¡£modeÖµ£ºIN¡¢OUT¡¢IN OUT£¬µ±mode δָ¶¨Ê±£¬±íʾΪIN
RETURN datatype ......