Oracle³£ÓÃÉÁ»Ø²Ù×÷

È·ÈÏÉÁ»ØÆôÓÃÖÐ
SHOW PARAMETER RECYCLEBIN; ÆôÓÃÉÁ»Ø
ALTER SYSTEM SET RECYCLEBIN = ON; ÉÁ»ØDROPµÄ±í
FLASHBACK TABLE xxx TO BEFORE DROP; ³¹µ×Çå³ýDROPµÄ±í,½«²»ÄÜÔÙÉÁ»Ø.
PURGE TABLE xxx; Ö±½Ó³¹µ×DROPµô±í
DROP TABLE xxx PURGE; Çå¿ÕËùÓÐDROPµÄ±í
PURGE RECYCLEBIN; È·ÈÏ×î´ó¿ÉÉÁ»Ø¶à¾Ã(ÃëÊý)֮ǰµÄDML²Ù×÷.(²»±£Ö¤)
SHOW PARAMETER undo_retention; ¸Ä±ä×î´ó¿ÉÉÁ»Ø¶à¾Ã֮ǰµÄDML²Ù×÷
ALTER SYSTEM SET undo_retention = 7200; ÉÁ»ØÎóDML²Ù×÷.ÒÔÎó²Ù×÷emp±íjob×Ö¶ÎΪÀý
a.)È·ÈÏÏàÓ¦µÄxid
SELECT versions_xid, job from emp VERSIONS BETWEEN SCN minvalue AND maxvalue;
b.)È·ÈÏÏàÓ¦ÐèÒªÖ´ÐеÄSQLÓï¾ä. ¼´ÊÇÏÂÃæ²éѯ½á¹û¼¯µÄUNDO_SQL×ֶεÄÄÚÈÝ
SELECT operation, start_scn, undo_sql from flashback_transaction_query WHERE xid = hextoraw('À´×ÔÉÏÒ»²éѯµÄxid');
c1.)Ö´ÐÐÏàÓ¦µÄSQLÓï¾ä. ±¾·½·¨±È½Ï׼ȷ,²»»áÓ°ÏìÖ®ºó·¢ÉúµÄÆäËû×ֶεı仯.
c2.)²»·½±ãÖ´ÐÐÉÏÒ»·½·¨Ê±,Ö´ÐÐÒÔÏÂÓï¾ä.×¢ÒâÔÚÏàÓ¦²Ù×÷Ö®ºó±íÖз¢ÉúµÄËùÓвÙ×÷¶¼½«±»»Ø¸´.
       FLASHBACK TABLE emp TO SCN À´×ÔÉÏÒ»²éѯµÄSCNºÅ;

       Èç¹ûÔÚÖ´ÐÐʱ³ö´í,²¢Ìáʾ¸Ã±íδÆôÓÃÐÐÒƹ¦ÄÜ(row movement),Ö´ÐÐÒÔÏÂÓï¾ä
       ALTER TABLE emp ENABLE ROW MOVEMENT;
c3.)Ò²¿ÉÒÔ»Ö¸´µ½Ä³Ò»Ê±¼äµã,¸Ãʱ¼äµãÖ®ºóµÄËùÓвÙ×÷¶¼½«±»»Ø¸´.to_timestampÒ²¿ÉÒÔʹÓÃÍêÕû¸ñʽ('2009-12-04 22:16:20', 'YYYY-MM-DD HH:MI:SS');
      FLASHBACK TABLE emp TO TIMESTAMP to_timestamp('17:35', 'hh23:mi');