Oracle undo »Ø¹ö¶Î¹ÜÀí
ÔÚ¿ªÊ¼Ö®Ç°£¬ÎÒÃÇÏÈÀ´Ë¼¿¼¼¸¸öÎÊÌ⣿
1. ora-01555´íÎóµÄÊÇÔõô²úÉúµÄ£¿ÓÐʲô°ì·¨½â¾ö£¿
¸ÃÎÊÌ⣬²Î¿¼ÎÒµÄBlog£º Oracle ORA-01555¿ìÕÕ¹ý¾É
http://blog.csdn.net/tianlesoftware/archive/2009/10/31/4745898.aspx
2. »Ø¹ö¶Î(»Ø¹ö±í¿Õ¼ä)ÓÐʲô×÷Óã¿
3. Êý¾Ý¿âÆô¶¯µÄʱºò£¬ÈçºÎ¼ÓÔػعö¶Î£¨»Ø¹ö¶Î±í¿Õ¼ä£©¡£
4. »Ø¹ö¶ÎµÄÊýÁ¿ÓÉʲô¹«Ê½À´¼ÆËã
5. »Ø¹ö±í¿Õ¼äµÄ´óСÈçºÎÈ·¶¨£¿
Ò». ʲôÊÇundo
OracleÊý¾Ý¿âÔÚ»ØÍË¡¢³·Ïú»òÕ߸ıäÊý¾ÝËùÐèÒªµÄά»¤Êý¾Ý¿âÐÅÏ¢µÄÒ»ÖÖÊֶΡ£ÕâÀïµÄÊý¾Ý¿âÐÅÏ¢ÊÇÖ¸ÔÚÊý¾Ý¿âÌύ֮ǰµÄ¼Ç¼µÄ¸Ä±äµÈÊÂÎñÐÅÏ¢¡£
Undo ÐÅÏ¢Ö÷ÒªÓÐÒÔÏÂÓÃ;£º
µ±ÏµÍ³·¢³örollbackÐÅÏ¢
Êý¾Ý¿â»Ö¸´
Ìṩ¶ÁÒ»ÖÂÐÔ
µ±ÏµÍ³·¢³örollbackÃüÁîʱ£¬undo ÐÅϢͨ¹ý¼Ç¼µÄÐÅÏ¢½«Êý¾Ý¿âµÄ¸Ä±ä»Ö¸´µ½commit֮ǰµÄ״̬¡£ÔÚÊý¾Ý¿â»Ö¸´Æڼ䣬undoÐÅÏ¢±»ÓÃÀ´´Óredo logÖг·ÏúÈκÎδÌá½»µ½Êý¾ÝÎļþµÄÊÂÎñ¡£µ±Ò»¸öÓû§ÔÚ·ÃÎÊÊý¾Ýʱ£¬Undo¼Ç¼ͨ¹ýά»¤·ÃÎÊÊý¾ÝµÄÇ°¾µÏñÊý¾ÝÀ´±£Ö¤µ±ÓÐÆäËûÓû§¸Ä±äÏàͬÊý¾ÝʱÊý¾Ý¿âµÄ¶ÁÒ»ÖÂÐÔ¡£
ÒÔÇ°Êý¾Ý¿âʹÓûعö¶ÎÀ´´æ´¢undoÐÅÏ¢£¬ÕâÖֻعö¶Î¹ÜÀí·½Ê½·Ç³£µÄ¸´ÔÓ¡£ÏÖÔÚÊý¾Ý¿â²ÉÓÃundoµÄ·½Ê½½µµÍÁ˹ÜÀíµÄ¸´ÔÓÐÔ£¬Í¬Ê±¼õÉÙÁËdbaµÄ¹¤×÷¸ººÉ¡£µ«ÊÇÔÚÊý¾Ý¿âÖ»ÄÜʹÓÃÕâÁ½ÖÖ·½Ê½µÄÒ»ÖÖ¡£¿ÉÒÔÔÚÊý¾Ý¿âÀﶨÒåÁ½ÖÖ·½Ê½µÄÎļþ£¬µ«ÊÇ£¬Í¬Ò»Ê±¿Ì£¬±ØÐëÖ¸¶¨Êý¾ÝʹÓÃÄÄÒ»ÖÖ·½Ê½¡£µ±ÄãÐèÒªÔÚÁ½ÖÖ·½Ê½ÖÐÇл»Ê±£¬±ØÐ뽫ϵͳÖØÐÂÆô¶¯¡£
OracleÊý¾Ý¿âһֱʹÓÃϵͳ»Ø¹ö¶ÎÀ´Íê³ÉϵͳµÄÊÂÎñ¡£ÏµÍ³»Ø¹ö¶ÎÊÇÔÚÊý¾Ý¿â,´´½¨µÄʱºò²úÉúµÄ£¬ÏµÍ³Æô¶¯ºó¾ÍÒ»Ö±ÔÚÏß¡£Dba²»ÐèÒª¶ÔËü×÷ÈκεIJÙ×÷À´ÓÅ»¯¡£
¶þ. Ö¸¶¨UndoµÄ·½Ê½
oracle 9iÒÔºóÓиö³õʼ»¯²ÎÊý£ºundo_management¡£µ±½«undo_managementÉèÖóÉAUTOʱϵͳʹÓÃÖØ×ö±í¿Õ¼äÀ´¹ÜÀí»Ø¹ö¶Î£¬µ±Ëü±»ÉèÖóÉMENUALʱϵͳʹÓûعö¶Î¡£
oracleÍƼöʹÓÃÖØ×ö±í¿Õ¼ä´úÌæ»Ø¹ö¶Î¡£
µ±ÏµÍ³Ê¹ÓÃauto·½Ê½¹ÜÀíundoÐÅϢʱ£¬ÏµÍ³±ØÐëÖ¸¶¨Ò»¸öundo±í¿Õ¼ä¡£Õâ¸ö±í¿Õ¼ä¿ÉÒÔÊÇÔÚÊý¾Ý¿â´´½¨Ê±²úÉú£¬Ò²¿ÉÒÔÊý¾Ý¿â´´½¨ºóÔÙ´´½¨¡£
µ±ÊµÀýÆô¶¯µÄʱºò£¬ÏµÍ³×Ô¶¯Ñ¡ÔñµÚÒ»¸öÓÐЧµÄundo±í¿Õ¼ä»òÕßÊÇrollback segment£¬Èç¹ûûÓÐÓÐЧµÄ¿ÉÓõÄundo±í¿Õ¼ä»òÕßÊǻعö¶Î£¬ÏµÍ³Ê¹ÓÃsystem rollback segment¡£ÕâÖÖÇé¿öÊDz»±»ÍƼöµÄ£¬µ±ÏµÍ³ÔËÐÐÔÚûÓÐundoµÄÇé¿öÏ£¬Ï
Ïà¹ØÎĵµ£º
1¡¢Èç¹ûÓÐÒ»¶¨µÄÊý¾Ý¿â»ù´¡£¬ÖªµÀSQLÊÇÔõô»ØÊ£¬¼´Ê¹Ð´²»³öÀ´¼òµ¥µÄSQL£¬µ«¿ÉÒÔ¿´¶¯ËüÃÇ£¬Äã¾Í¿ÉÒÔÌøµ½2¡£·ñÔòÇëÏÈ¿´Ò»ÏÂÊý¾Ý¿â»ù´¡ºÍSQLÓïÑÔ£¬²»ÐèÒªºÜÉ¸ü²»ÐèҪȥ¼ÇÒäÄÇЩ¸´ÔÓµÄSQLÃüÁÕâЩ¿ÉÒÔÁôÔÚÒÔºó±ßÓ¦Óñßѧϰ¡¢¼ÇÒä¡£
¡¡¡¡
¡¡¡¡2¡¢ÒªÏëѧºÃORACLE£¬Ê×ÏÈҪѧϰORACLEµÄÌåϵ½á¹¹£¬ÏÖÔÚÄã²»ÐèÒªÉîÈëÀ ......
The following are number examples for the to_char function.
to_char(1210.73, '9999.9')
would return '1210.7'
to_char(1210.73, '9,999.99')
would return '1,210.73'
to_char(1210.73, '$9,999.00')
would return '$1,210.73'
to_char(21, '000099')
would return '000021'
The following is a list ......
oracle ÖÐ TO_DATE º¯ÊýµÄʱ¼ä¸ñʽ£¬ÒÔ 2008-09-10 23:45:56 ΪÀý
¸ñʽ
˵Ã÷
ÏÔʾֵ
±¸×¢
Year(Äê):
yy
two digits(Á½Î»Äê)
08
yyy
three digits(ÈýλÄê)
008
yyyy
four digits(ËÄλÄê)
2008
Month(ÔÂ):
mm
number(Á½Î»ÔÂ)
09
mon
abbre ......
SQLÖеĵ¥¼Ç¼º¯Êý
1.ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii('A') A,ascii('a') a,ascii('0') zero,ascii(' ') space from dual;
A A ZERO ......