Oracle Flashback table的使用.pdf

ZZhhoonngg WWeeiicchheenngg SSttuuddyy NNootteess IInnssiisstt oonn hhiiss oowwnn iiddeeaall,, aanndd ttoo aattttaaiinn iitt.. OOrraaccllee FFllaasshhbbaacckk ttaabbllee的的使使用用 类： Oracle 2013-11-29 18:30 247人阅读 评论 (0) 收藏 举报 Oracle 确保recyclebin是打开的 SQL show parameter recyclebin NAME TYPE VALUE recyclebin strin ON 创建一张表 SQL create table tab01(id int); Table created. SQL insert into tab01 values(1); 1 row created. SQL commit; Commit complete. SQL select * from tab01; ID 1 SQL create index ind_id on tab01(id); Index created. 删除表TAB01 18:18:26 SQL select index_name from ind where table_name=TAB01; INDEX_NAME IND_ID 18:18:33 SQL drop table tab01; Table dropped. 18:18:41 SQL show recyclebin ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME TAB01 BIN$7E8nf4eZQZz QKjACz fM ==$0 TABLE 2013-11-29:18:18:41 18:18:43 SQL select index_name from ind where table_name=TAB01; no rows selected 18:18:50 SQL select * from tab01; 1 select * from tab01 * ERROR at line 1: ORA-00942: table or view does not exist 发现TAB01上的index也被rename，flashback TAB01 18:19:41 SQL flashback table tab01 to before drop; Flashback complete. 18:19:51 SQL select * from tab01; ID 1 18:19:54 SQL select index_name from ind where table_name=TAB01; INDEX_NAME BIN$7E8nf4eYQZz QKjACz fM ==$0 rename index 18:23:09 SQL ALTER INDEX BIN$7E8nf4eYQZz QKjACz fM ==$0 RENAME TO IDX_ID; Index altered. 18:23:45 SQL select index_name,status from ind where table_name=TAB01; INDEX_NAME STATUS IDX_ID VALID 如果多次删除同一张表也可以指定recyclebin的名称flashback 18:25:29 SQL select * from tab01; ID 1 18:25:36 SQL drop table tab01;