引言;閃回技術(shù): 優(yōu)點;閃回各種錯誤;閃回數(shù)據(jù)庫: 概述;如何啟用Oracle10g閃回數(shù)據(jù) oracle修復庫特性;準備測試數(shù)據(jù);進行閃回操作;進行閃回操作;閃回數(shù)據(jù)庫: 節(jié)省恢復時間;閃回數(shù)據(jù)庫: 注意事項;閃回數(shù)據(jù)庫: 局限;允許數(shù)據(jù)庫閃回(EM);閃回表: 概述;閃回表;允許表的行可移特征;執(zhí)行閃回表操作;閃回表;閃回表操作: 注意事項;閃回Drop: 概述;閃回drop;在Enterprise Manager中執(zhí)行閃回DROP操作;閃回drop;purge table t_user;

show recyclebin;;閃回Drop: 注意事項;閃回dml查詢;閃回查詢: 概述;閃回查詢: 示例;使用Flashback version Query;--下面我們利用VERSIONS_XID來查詢undo語句，需要用到sys/system用戶。兆柏數(shù)據(jù)恢復公司最后利用這些undo來撤銷不同版本的事物。

SELECT UNDO_SQL FROM FLASHBACK_TRANSACTION_QUERY where XID="0A001700C0020000";

SELECT UNDO_SQL FROM FLASHBACK_TRANSACTION_QUERY where XID="07000F00C5020000";

SELECT UNDO_SQL FROM FLASHBACK_TRANSACTION_QUERY where XID=F020000";

SELECT UNDO_SQL FROM FLASHBACK_TRANSACTION_QUERY where XID="02001B0010030000";

insert into "SJH"."SJH0"("USERNAME","USER_ID") values ("SYS","0");

insert into "SJH"."SJH0"("USERNAME","USER_ID") values ("SYSTEM","5");

update "SJH"."SJH0" set "USER_ID" = "55" where ROWID = "AAAM3JAAEAAAABMAAF";

update "SJH"."SJH0" set "USER_ID" = "54" where ROWID = "AAAM3JAAEAAAABMAAU";

commit;

select * from sjh0;

--完成事務的撤銷。

--Flashback transaction query需要用到 FLASHBACK_TRANSACTION_QUERY視圖。這個視圖來源于

x$ktuqqry表且xid字段上不存在索引，所以走的是全表掃描。x$ktuqqry的查詢非常耗時，所以請注意評估你的恢復成本。;練習: 使用閃回操作引言;閃回技術(shù): 優(yōu)點;閃回各種錯誤;閃回數(shù)據(jù)庫:oracle修復 概述;如何啟用Oracle10g閃回數(shù)據(jù)庫特性;準備測試數(shù)據(jù);進行閃回操作;進行閃回操作;閃回數(shù)據(jù)庫: 節(jié)省恢復時間;閃回數(shù)據(jù)庫: 注意事項;閃回數(shù)據(jù)庫: 局限;允許數(shù)據(jù)庫閃回(EM);閃回表: 概述;閃回表;允許表的行可移特征;執(zhí)行閃回表操作;閃回表;閃回表操作: 注意事項;閃回Drop: 概述;閃回drop;在Enterprise Manager中執(zhí)行閃回DROP操作;閃回drop;purge table t_user;

show recyclebin;;閃回Drop: 注意事項;閃回dml查詢;閃回查詢: 概述;閃回查詢: 示例;使用Flashback version Query;--下面我們利用VERSIONS_XID來查詢undo語句，需要用到sys/system用戶。最后利用這些undo來撤銷不同版本的事物。

SELECT UNDO_SQL FROM FLASHBACK_TRANSACTION_QUERY where XID="0A001700C0020000";

SELECT UNDO_SQL FROM FLASHBACK_TRANSACTION_QUERY where XID="07000F00C5020000";

SELECT UNDO_SQL FROM FLASHBACK_TRANSACTION_QUERY where XID=F020000";

SELECT UNDO_SQL FROM oracle修復 FLASHBACK_TRANSACTION_QUERY where XID="02001B0010030000";

insert into "SJH"."SJH0"("USERNAME","USER_ID") values ("SYS","0");

insert into "SJH"."SJH0"("USERNAME","USE