Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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ÀëÏß·ÃÎÊ---ÇóÖú - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄԭʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
    ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

OracleÈÏÖ¤ - Oracle / ÈÏÖ¤Ó뿼ÊÔ

ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ 
Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£
¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉOracle¹«Ë¾³öÌâ¡£
¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ