oracle»Ø¹öÎÊÌ⣬ÔÚÏߵȼ±!!! - Oracle / ¿ª·¢
¸Õ²Å×öÀ²Ò»¸ö¸üÐÂÓï¾ä£¬Íü¼Ç´øÌõ¼þÀ²°ÑÕû¸ö±í¶¼¸üÐÂÀ²¡£ÒªÔõô»Ø°ì
ÖªµÀµÄ¼ÓÎÒQQлл375738283 10g flashback 16¶Ô±íµÄʱ¼ä¶ÎÉÁ»Ø ±ØÐëÓÐȨÏÞ grant flashback any table to newtest ±ØÐëÏÈÖ´ÐÐalter table biao1 enable row movement; flashback table biao1 to timestamp to_timestamp('2010-5-31 11:53:17','yyyy-mm-dd hh24:mi:ss')ÒýÓà ¸Õ²Å×öÀ²Ò»¸ö¸üÐÂÓï¾ä£¬Íü¼Ç´øÌõ¼þÀ²°ÑÕû¸ö±í¶¼¸üÐÂÀ²¡£ÒªÔõô»Ø°ì ±íÉÁ»Ø ÔÙ¸üлØÈ¥²»¾Í¿ÉÒÔÁËÒýÓà ¸Õ²Å×öÀ²Ò»¸ö¸üÐÂÓï¾ä£¬Íü¼Ç´øÌõ¼þÀ²°ÑÕû¸ö±í¶¼¸üÐÂÀ²¡£ÒªÔõô»Ø°ì -- »¹Ã»commitµÄ»°£¬¾Írollback£»Èç¹ûÒѾcommitÁ˵ϰ£¬¾ÍÀûÓñíÉÁ»Ø(flastback)! -- ¶Ô£º¸üÐÂÌõ¼þÔõôдµÄ£¿ -- Ó¦¸Ã£ºÄÜÔÙ¸üлØÈ¥µÄÂï! -- µ±È»£ºÊÇ×Ö·ûÐ͵ϰ£¬ºÜÄѸüлØÈ¥! -- ÊýÖµÐ͵ϰ£¬ºÃµã! rollback һϠflashback ֻҪûcommit ¾Írollback Ò»ÏÂÊÇ¿ÉÒÔ¶ÔÊÂÎñµÄ²Ù×÷½øÐлعöµÄ£¬¶ÔÓÚDDL£¨¶¨ÒåÓïÑÔ£©ÊÇÎÞЧµÄ°É£¡ÒýÓà ֻҪûcommit ¾Írollback Ò»ÏÂÊÇ¿ÉÒÔ¶ÔÊÂÎñµÄ²Ù×÷½øÐлعöµÄ£¬¶ÔÓÚDDL£¨¶¨ÒåÓïÑÔ£©ÊÇÎÞЧµÄ°É£¡ -- ÊǵģºÊÇÎÞЧµÄ£¬µ«ÕâÊǸüÐÂÓï¾ä°¡!²»ÊôÓÚDDLÓïÑÔ°¡(CREATE/ALTER/DROP...)! Èç¹ûÊÇ10G ÒÔϰ汾 ÆÚÅÎÂ¥Ö÷ûÓÐCOMMIT ¼ÙÈçûÓÐflashback, ¿ÉÒÔÊÔÊÔ logminer£¬»òÐíÄÜÕÒ»Ø ¼ÙÈçÊÇtruncateµÄ»°£¬¾Íû¾ÈÁË£¬µÃÓñ¸·ÝÀ´»¹Ô¡£ ¼ÙÈçÊÇdeleteµÄ»°£¬¿ÉÒÔÊÇ£ºflashback table T to timestamp t
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ ÒýÓà ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......
ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£ ¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉOracle¹«Ë¾³öÌâ¡£ ¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿ ......