ͨ¹ý´´½¨ÐòÁÐÀ´ÊµÏÖORACLE SEQUENCEµÄ¼òµ¥½éÉÜ
ÔÚoracleÖÐsequence¾ÍÊÇËùνµÄÐòÁкţ¬Ã¿´ÎÈ¡µÄʱºòËü»á×Ô¶¯Ôö¼Ó£¬Ò»°ãÓÃÔÚÐèÒª°´ÐòÁкÅÅÅÐòµÄµØ·½¡£
1¡¢Create Sequence
ÄãÊ×ÏÈÒªÓÐCREATE SEQUENCE»òÕßCREATE ANY SEQUENCEȨÏÞ£¬
CREATE SEQUENCE emp_sequence
INCREMENT BY 1 -- ÿ´Î¼Ó¼¸¸ö
START WITH 1 -- ´Ó1¿ªÊ¼¼ÆÊý
NOMAXVALUE -- ²»ÉèÖÃ×î´óÖµ
NOCYCLE -- Ò»Ö±ÀÛ¼Ó£¬²»Ñ»·
CACHE 10;
Ò»µ©¶¨ÒåÁËemp_sequence£¬Äã¾Í¿ÉÒÔÓÃCURRVAL£¬NEXTVAL
CURRVAL=·µ»Ø sequenceµÄµ±Ç°Öµ
NEXTVAL=Ôö¼ÓsequenceµÄÖµ£¬È»ºó·µ»Ø sequence Öµ
±ÈÈ磺
emp_sequence.CURRVAL
emp_sequence.NEXTVAL
¿ÉÒÔʹÓÃsequenceµÄµØ·½£º
- ²»°üº¬×Ó²éѯ¡¢snapshot¡¢VIEWµÄ SELECT Óï¾ä
- INSERTÓï¾äµÄ×Ó²éѯÖÐ
- NSERTÓï¾äµÄVALUESÖÐ
- UPDATE µÄ SETÖÐ
¿ÉÒÔ¿´ÈçÏÂÀý×Ó£º
INSERT INTO emp VALUES
(empseq.nextval, 'LEWIS', 'CLERK',7902, SYSDATE, 1200, NULL, 20);
SELECT empseq.currval from DUAL;
µ«ÊÇҪעÒâµÄÊÇ£º
- µÚÒ»´ÎNEXTVAL·µ»ØµÄÊdzõʼֵ£»ËæºóµÄNEXTVAL»á×Ô¶¯Ôö¼ÓÄ㶨ÒåµÄINCREMENT BYÖµ£¬È»ºó·µ»ØÔö¼ÓºóµÄÖµ¡£CURRVAL ×ÜÊÇ·µ»Øµ±Ç°SEQUENCEµÄÖµ£¬µ«ÊÇÔÚµÚÒ»´ÎNEXTVAL³õʼ»¯Ö®ºó²ÅÄÜʹÓÃCURRVAL£¬·ñÔò»á³ö´í¡£Ò»´ÎNEXTVAL»áÔö¼ÓÒ»´ÎSEQUENCEµÄÖµ£¬ËùÒÔÈç¹ûÄãÔÚͬһ¸öÓï¾äÀïÃæʹÓöà¸öNEXTVAL£¬ÆäÖµ¾ÍÊDz»Ò»ÑùµÄ¡£Ã÷°×£¿
- Èç¹ûÖ¸¶¨CACHEÖµ£¬ORACLE¾Í¿ÉÒÔÔ¤ÏÈÔÚÄÚ´æÀïÃæ·ÅÖÃһЩsequence£¬ÕâÑù´æÈ¡µÄ¿ìЩ¡£cacheÀïÃæµÄÈ¡Íêºó£¬oracle×Ô¶¯ÔÙÈ¡Ò»×éµ½cache¡£ ʹÓÃcache»òÐí»áÌøºÅ£¬ ±ÈÈçÊý¾Ý¿âͻȻ²»Õý³£downµô£¨shutdown abort),cacheÖеÄsequence¾Í»á¶ªÊ§. ËùÒÔ¿ÉÒÔÔÚcreate sequenceµÄʱºòÓÃnocache·ÀÖ¹ÕâÖÖÇé¿ö¡£
2¡¢Alter Sequence
Äã»òÕßÊǸÃsequenceµÄowner£¬»òÕßÓÐALTER ANY SEQUENCE ȨÏÞ²ÅÄܸĶ¯sequence. ¿ÉÒÔalter³ýstartÖÁÒÔÍâµÄËùÓÐsequence²ÎÊý.Èç¹ûÏëÒª¸Ä±ästartÖµ£¬±ØÐë drop sequence ÔÙ re-create .
Alter sequence µÄÀý×Ó
ALTER SEQUENCE emp_sequence
INCREMENT BY 10
MAXVALUE 10000
CYCLE -- µ½10000ºó´ÓÍ·¿ªÊ¼
NOCACHE ;
Ó°ÏìSequenceµÄ³õʼ»¯²ÎÊý£º
SEQUENCE_CACHE_ENTRIES =ÉèÖÃÄÜͬʱ±»cacheµÄsequenceÊýÄ¿¡£
¿ÉÒԺܼòµ¥µÄDrop Sequence
DROP SEQUENCE order_seq;
Ïà¹ØÎĵµ£º
ÔÎĵØÖ·£ºhttp://book.csdn.net/bookfiles/732/10073222578.shtml
¶ÔÓÚDMLÓï¾äÀ´Ëµ£¬Ö»ÒªÐÞ¸ÄÁËÊý¾Ý¿é£¬OracleÊý¾Ý¿â¾Í»á½«ÐÞ¸ÄÇ°µÄÊý¾Ý±£ÁôÏÂÀ´£¬±£´æÔÚundo segmentÀ¶øundo segmentÔò±£´æÔÚundo±í¿Õ¼äÀï¡£´ÓOracle 9iÆð£¬ÓÐÁ½ÖÖundoµÄ¹ÜÀí·½Ê½£º×Ô¶¯Undo¹ÜÀí£¨Automatic Undo Management£¬¼ò³ÆAUM£©ºÍÊÖ¹¤Undo¹ÜÀí£¨ ......
ORACLE 10.204ÃÜÂëÖØÊÔ´ÎÊýÎÊÌâ
ORACLE 10.204ÃÜÂëÖØÊÔ´ÎÊýÎÊÌâ
ORACLE 10.204²¹¶¡ÔöÇ¿ÁËϵͳµÄ°²È«ÐÔ£¬È±Ê¡µÄÃÜÂëÖØÊÔ´ÎÊý¸ÄΪÁË10´Î£¬ÕâÔںܶàÇé¿öÏ£¬»áµ¼ÖÂһЩ¿Í»§±»Ëø¶¨£¬Èç¹ûÏëÐÞ¸ÄÃÜÂëÖØÊÔ´ÎÊý£¬¿ÉÒÔÐÞ¸ÄÏìÓ¦µÄ¸ÅÒªÎļþ£¬Èç¹ûûÓд´½¨Óû§¸ÅÒªÎļþ£¬È±Ê¡µÄ¾ÍÊÇÓÃoracleµÄ¸ÅÒªÎļþ£¬ÐÞ¸ÄÕâ¸ö¸ÅҪΠ......
oracle¾Þ´ó±íµÄÊý¾Ýɾ³ýµÄ·½·¨£¬20·ÖÖӸ㶨
Ò»¸ö¿Í»§µÄÈÕÖ¾±í£¬ÒѾÓÐ3000¶àǧÍòµÄ¼Ç¼ÁË£¬ÈÝÁ¿´óÔ¼30G£¬´òËãά»¤Ò»Ï£¬¿´ÁËÒ»ÏÂ×ֶΣ¬·¢ÏÖÈÕÖ¾ÊÇ°´ÈÕÆڼǼµÄ£¬´òËãÖ»±£Áô3¸öÔµÄÈÕÖ¾¾ÍºÃÁË¡£
µÚÒ»¸ö˼·£º
°´Ìõ¼þ²é³öÀ´£¬Ö±½ÓDELETE
ÊÔÁËÒ»ÏÂ
delete from NTLS_LOGS where to_char(START ......
WINDOWSÏ ORACLE ÕìÌý³ÌÐòÒ쳣ֹͣ¹ÊÕÏ´¦Àí
WINDOWSÏ ORACLE ÕìÌý³ÌÐòÒ쳣ֹͣ¹ÊÕÏ´¦Àí
¼ÒÀïÓÃÀ´µĄ̈ʽ»úÉÏ×°Á˸öWINDOWSϵÄORACLE 10G,ºÃ¾ÃûÓÃÁË£¬½ñÌì´ò¿ª´òËãÓÃһϣ¬Æô¶¯Êý¾Ý¿â£¬Æô¶¯ÕìÌý£¬¿´×źÜÕý³££¬µ«ÊÇÔÚ¿Í»§¶ËµÄTNSPING
C:\>tnsping homedb
TNS Ping Utility for 32-bit Window ......