Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎÊ´ð£º

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

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

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

oracle²¢·¢´¦ÀíSOS - Oracle / ¿ª·¢

ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾ­ºÜ³ÉÊìÁË

ÒýÓÃ
oracle ......

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

ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ 
Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£
¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉOracle¹«Ë¾³öÌâ¡£
¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿ ......

¸ß·ÖÇó½âOracleÊý¾Ý¿âµÄÁéÒìʼþ - Oracle / ¿ª·¢

½ñÌìÓöµ½Ò»¸öºÜ¹îÒìµÄÎÊÌâ¡£ÎÒÔÚÒ»ÕűíÖÐÐÂÔöÁËÒ»¸ö×ֶΡ£È»ºóÓÃÈçϽű¾¸üÐÂÕâ¸ö×ֶεÄÖµ£º
SQL code:

update ibp_fund_information_tab set yield = 7.4520 where fund_code = '040003' and info_date = ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ