oracle »ØÍ˶Îά»¤
»Ø¹ö¶ÎÓÃÓÚ¶ÔÊý¾Ý¿âÐÞ¸Äʱ, ±£´æÔÓеÄÊý¾Ý, ÒÔ±ãÉÔºó¿ÉÒÔͨ¹ýʹÓÃROLLBACKÀ´»Ö¸´µ½ÐÞ¸ÄǰµÄÊý¾Ý; ÁíÍâ, »Ø¹ö¶Î¿ÉÒÔΪÊý¾Ý¿âÖеÄËùÓнø³ÌÌṩ¶ÁÒ»ÖÂÐÔ. Òò´Ë, »Ø¹ö¶ÎÉèÖõĺÏÀíÓë·ñ, Ö±½ÓÓ°Ïìµ½Êý¾Ý¿âµÄÐÔÄÜ.
»Ø¹ö¶ÎµÄά»¤¼°²éѯ
(1) ´´½¨»Ø¹ö¶Î
__CREATE ROLLBACK SEGMENT RB01
__TABLESPACE RBS1
__STORAGE (
____INITIAL 100K
____NEXT 100K
____MINEXTENTS 20
____MAXEXTENTS 100
____OPTIMAL 2000K );
2) ¸ü¸ÄONLINE/OFFLINE״̬
__ALTER ROLLBACK SEGMENT RB01 ONLINE;
__ALTER ROLLBACK SEGMENT RB01 OFFLINE;
(3) ¸ü¸ÄOPTIMAL²ÎÊý
__ALTER ROLLBACK SEGMENT RB01
__STORAGE ( MAXEXTENTS 200
____OPTIMAL 2048K );
(4) ËõС»Ø¹ö¶Î
__ALTER ROLLBACK SEGMENT RB01 SHRINK;
(ÓÐOPTIMAL²ÎÊýʱ, ËõСµ½OPTIMALÖµ; ûÓÐOPTIMAL²ÎÊýʱ, ËõСµ½MINEXTENTSËù¶ÔÓ¦µÄ³ß´ç)
__ALTER ROLLBACK SEGMENT RB01 SHRINK TO 2048K;
(5) ÐÞ¸ÄINITIAL/NEXT²ÎÊý
*** ½¨Òé5: ¸ù¾ÝÔÔò3, ÐÞ¸ÄNEXTʱ, ×ÜÓ¦¸ÃͬʱÐÞ¸ÄINITIAL.
INITIAL²ÎÊýÎÞ·¨Ö±½ÓÐÞ¸Ä, Ö»ÄÜÏÈDROP, È»ºóÔÙCREATE.
__DROP ROLLBACK SEGMENT RB01;
__CREATE ROLLBACK SEGMENT RB01
__TABLESPACE RBS1
__STORAGE ( INITIAL 100K
____NEXT 100K
____MINEXTENTS 20
____MAXEXTENTS 121
____OPTIMAL 2000K )
(6) ÔÚÊÂÎñÖÐʹÓÃÌØ¶¨µÄ»Ø¹ö¶Î
__SET TRANSACTION USE ROLLBACK SEGMENT RB_LARGE1;
(7) ³£ÓõÄÓйػعö¶ÎµÄϵͳÊý¾Ý×Öµä
DBA_ROLLBACK_SEGS (Ïà¹Ø±í:DBA_SEGMENTS)
V$ROLLNAME
V$ROLLSTAT
V$TRANSACTION (Ïà¹Ø±í: V$SESSION)
Óйػعö¶ÎµÄ³£¼û´íÎó¼°½â¾ö·½·¨
(1) »Ø¹ö¶Î¿Õ¼ä²»¹»
ORA-01562 - failed to extend rollback segment number string
»Ø¹ö¶Î¿Õ¼ä²»¹»µÄÔÒòÒ»°ãÓÐÒÔϼ¸ÖÖÇé¿ö:
A. »Ø¹ö¶ÎËùÔÚ±í¿Õ¼äÊ£ÓàµÄ¿ÕÏпռä̫С, ÎÞ·¨·ÖÅäÏÂÒ»¸öEXTENT.
B. »Ø¹ö¶ÎÀ©Õ¹´ÎÊýÒѾ´ïµ½MAXEXTENTSÏÞÖÆ
½â¾ö·½·¨:
A. À©´ó»Ø¹ö¶ÎËùÔÚ±í¿Õ¼ä
B. ÉèÖýϴóµÄMAXEXTENTS²ÎÊý
C. Ϊ»Ø¹ö¶ÎÉèÖÃOPTIMAL²ÎÊý
D. ÓýϴóµÄEXTENT²ÎÊýÖØÐ´´½¨»Ø¹ö¶Î
±¾ÎÄÀ´×ÔCSDN²©¿Í£¬×ªÔØÇë±êÃ÷³ö´¦£ºhttp://blog.csdn.net/tianzhichengzhr/archive/2009/11/06/4776380.aspx
Ïà¹ØÎĵµ£º
ʲôÊǺϲ¢¶àÐÐ×Ö·û´®£¨Á¬½Ó×Ö·û´®£©ÄØ£¬ÀýÈ磺
SQL> desc test;
Name Type Nullable Default Comments
------- ------------ -------- ------- --------
COUNTRY VARCHAR2(20) Y &nb ......
ʲôÊǺϲ¢¶àÐÐ×Ö·û´®£¨Á¬½Ó×Ö·û´®£©ÄØ£¬ÀýÈ磺
SQL> desc test;
Name Type Nullable Default Comments
------- ------------ -------- ------- --------
COUNTRY VARCHAR2(20) Y &nb ......
Ò»£º»Ø¹ö¶Î¸ÅÊö
¡¡¡¡»Ø¹ö¶ÎÓÃÓÚ´æ·ÅÊý¾ÝÐÞ¸Ä֮ǰµÄÖµ£¨°üÀ¨Êý¾ÝÐÞ¸Ä֮ǰµÄλÖúÍÖµ£©¡£»Ø¹ö¶ÎµÄÍ·²¿°üº¬ÕýÔÚʹÓõĸûعö¶ÎÊÂÎñµÄÐÅÏ¢¡£Ò»¸öÊÂÎñÖ»ÄÜʹÓÃÒ»¸ö»Ø¹ö¶ÎÀ´´æ·ÅËüµÄ»Ø¹öÐÅÏ¢£¬¶øÒ»¸ö»Ø¹ö¶Î¿ÉÒÔ´æ·Å¶à¸öÊÂÎñµÄ»Ø¹öÐÅÏ¢¡£
»Ø¹ö¶ÎµÄ×÷ÓÃ
¡¡¡¡ÊÂÎñ»Ø¹ö£ºµ±ÊÂÎñÐ޸ıíÖÐÊý¾ÝµÄʱºò£¬¸ÃÊý¾ÝÐÞ¸ÄǰµÄÖµ£¨¼´Ç°Ó°Ïñ£ ......
Oracle´æ´¢¹ý³Ì°üº¬Èý²¿·Ö£º¹ý³ÌÉùÃ÷£¬Ö´Ðйý³Ì²¿·Ö£¬´æ´¢¹ý³ÌÒì³£¡£
Oracle´æ´¢¹ý³Ì¿ÉÒÔÓÐÎÞ²ÎÊý´æ´¢¹ý³ÌºÍ´ø²ÎÊý´æ´¢¹ý³Ì¡£
Ò»¡¢Î޲γÌÐò¹ý³ÌÓï·¨
1 create or replace procedure NoParPro
2 as ;
3 begin
4 ;
5 exception &nb ......
ÒÔǰ¾³£Ê¹ÓÃoracleµÄ¿Í»§¶Ë¹¤¾ßtoadÀ´½øÐÐÊý¾Ý¿âµÄµ¼ÈëºÍµ¼³ö£¬Æäʵ¸öÈ˵¹²»Ï²»¶ÓÃÕâ¸ö¿Í»§¶Ë¹¤¾ß£¬¸Ð¾õ¹¦ÄܺÜÇ¿´óµÄÒ»¸ö¹¤¾ß£¬dbaÊÊÓ᣿ª·¢»¹ÊÇÓÃpl/sql±È½ÏºÃ£¬¼ò½àµÄ½çÃæ¡£
C:\Users\Administrator>imp nwgis/pass file=e:/nwgis20100529.DMP log=dible_db full=y ignore=y
Æô¶¯ÃüÁîÐУ¬ÐÞ¸Ä ......