Oracle Flashback ¼¼Êõ×ܽá
»¨Á˵ãʱ¼ä£¬ ¶ÔORACLE Flashback ¼¼Êõ×öÁ˸ö×ܽᣬ ÄÚÈݱȽϳ¤£¬ ²»¹ýÈç¹ûÄÜÄÍÐĵĿ´Íê²¢¶¯ÊÖ²Ù×÷Ï£¬Ó¦¸Ã»áÓкܶàÊÕ»ñ¡£ÖÁÉÙÄÜÀí½âFlashback ÊÇʲô¶«Î÷ÁË. ÕûÀíÕâЩ»¨ÁË2ÌìµÄʱ¼ä£¬ word 24Ò³Ö½£¬ »¹µ£ÐÄһƪ·¢²»ÁË£¬ ²»¹ýCSDNûÈÃÎÒʧÍû¡£ Ò»Ìù·¢ÏÂÈ¥ÁË.
Flashback ¼¼ÊõÊÇÒÔUndo segmentÖеÄÄÚÈÝΪ»ù´¡µÄ£¬ Òò´ËÊÜÏÞÓÚUNDO_RETENTON²ÎÊý¡£ÒªÊ¹ÓÃflashback µÄÌØÐÔ£¬±ØÐëÆôÓÃ×Ô¶¯³·Ïú¹ÜÀí±í¿Õ¼ä¡£
ÔÚOracle 10gÖУ¬ Flash back·ÖΪÒÔϳÉÔ±£º Flashback Database£¬ Flashback Drop£¬Flashback Query(·ÖFlashback Query,Flashback Version Query£¬ Flashback Transaction Query ÈýÖÖ) ºÍFlashback Table¡£
...
Oracle Flashback ¼¼Êõ×ܽá
http://blog.csdn.net/tianlesoftware/archive/2009/10/15/4677378.aspx
Ö§³Öһϼ¼ÊõÌù
¹²Í¬Ñ§Ï°ÁË.¡¡ºÇºÇ
ÓÖ¿´¼û "C'est la Vie"ÁË.¡¡Ò»Í¬ÊµÄQQÇ©ÃûÒ²ÊÇÕâ¸ö.²»ÖªµÀʲôÒâ˼£¬¸ÕgoogleÏ£¬
"C'est la Vie"£º ·¨Óï,Õâ¾ÍÊÇÉú»îµÄÒâ˼.Ï൱ÓÚÓ¢ÓïµÄThis is life.
×î½üÁ÷Ðз¨ÓïÁË£¿
ÕâÊÇÊ׸èÃû£¬Ò²ÊÇ·¨¹úÈ˳£ÓõĿÚÍ·Óï
²»´í ²»´í£¬Ö§³Ö
»¶Ó´ó¼Òµ½ "OracleʵÓÃÂÛ̳" ×ܽύÁ÷
ѧϰÁË
ѧϰÖÐ.....
ÆÚÍû¸ü¶àºÃÌù
¹Ø×¢
Ïà¹ØÎÊ´ð£º
ÎÒ°²×°Ò»Ì¨redhat linux5+oracle 10gµÄ·þÎñÆ÷£¬±Ê¼Ç±¾£¨XPϵͳ£©°²×°ÁËoracle 10g¿Í»§¶Ë,½á¹ûÀÏÊdzö12560µÄ´íÎó£¬Çë¸ßÊÖÖ¸µãÒ»¶þ£¬
-A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dpor ......
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ֪µÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......
µ¼³ö¡¢µ¼Èë¶¼ÊÇ oracle 10g ¡£
ÔÚµ¼Èë¹ý³ÌÖгöÏÖÈçÏÂÇé¿ö£º
IMP-00017: ÓÉÓÚ ORACLE ´íÎó 6550, ÒÔÏÂÓï¾äʧ°Ü:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '4E014E50 ......
±í½á¹¹£º
union sex
004 2
002 2
002 2
003 1
002 1
ÏÖÔÚÎÒÏëÏÔʾÕâÑùµÄ½á¹û
1 2
002 & ......