Backup And Recovery User's Guide-當多個物件共享相同的原始名稱的時候獲取物件
當多個物件共享相同的原始名稱的時候獲取物件
可以建立然後刪除具有相同原始名稱的多個物件。所有被刪除的物件都儲存在回收站中。
-- temp_employees version 1 CREATE TABLE temp_employees ( ...columns ); DROP TABLE temp_employees; -- temp_employees version 2 CREATE TABLE temp_employees ( ...columns ); DROP TABLE temp_employees; -- temp_employees version 3 CREATE TABLE temp_employees ( ...columns ); DROP TABLE temp_employees;
--每一個表temp_employees在回收站中都被指定了一個唯一的名稱。使用原始名稱閃回刪除, 具有這個原始名稱的最近被刪除的表從回收站被獲取 FLASHBACK TABLE temp_employees TO BEFORE DROP;
--獲取3個被刪除的相同名稱的表,並指定新的名稱.最後被刪除的表最先被獲取 FLASHBACK TABLE temp_employees TO BEFORE DROP RENAME TO temp_employees_VERSION_3; FLASHBACK TABLE temp_employees TO BEFORE DROP RENAME TO temp_employees_VERSION_2; FLASHBACK TABLE temp_employees TO BEFORE DROP RENAME TO temp_employees_VERSION_1;
--使用唯一的回收站名稱從回收站獲取表,這樣就可以不用管原始名稱中的衝突 --檢視 SELECT object_name, original_name, createtime FROM recyclebin;
OBJECT_NAME ORIGINAL_NAME CREATETIME ------------------------------ --------------- ------------------- BIN$yrMKlZaLMhfgNAgAIMenRA==$0 TEMP_EMPLOYEES 2007-02-05:21:05:52 BIN$yrMKlZaVMhfgNAgAIMenRA==$0 TEMP_EMPLOYEES 2007-02-05:21:25:13 BIN$yrMKlZaQMhfgNAgAIMenRA==$0 TEMP_EMPLOYEES 2007-02-05:22:05:53 --還原 FLASHBACK TABLE BIN$yrMKlZaVMhfgNAgAIMenRA==$0 TO BEFORE DROP; |
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17013648/viewspace-1097336/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Backup And Recovery User's Guide-當不使用恢復目錄時的特殊考慮GUIIDE
- Backup And Recovery User's Guide-時間點恢復的基本概念GUIIDE
- Backup And Recovery User's Guide-還原歸檔重做日誌到多個位置GUIIDE
- Backup And Recovery User's Guide-進行臨時歸檔備份GUIIDE
- Backup And Recovery User's Guide-使用RECOVER命令的自動恢復GUIIDE
- Backup And Recovery User's Guide-禁用塊改變跟蹤GUIIDE
- Backup And Recovery User's Guide-執行資料庫時間點恢復GUIIDE資料庫
- Backup And Recovery User's Guide-對於SUSPENDED資料庫的備份GUIIDE資料庫
- Backup And Recovery User's Guide-執行完全自動的RMAN TSPITRGUIIDE
- Backup And Recovery User's Guide-閃回刪除的先決條件GUIIDE
- Backup And Recovery User's Guide-從RMAN開始-恢復單個的資料塊GUIIDE
- Backup And Recovery User's Guide-建立和更新增量備份GUIIDE
- Backup And Recovery User's Guide-聯機重做日誌切換GUIIDE
- Backup And Recovery User's Guide-執行閃回刪除操作GUIIDE
- Backup And Recovery User's Guide-閃回技術基本概念GUIIDE
- Backup And Recovery User's Guide-閃回和資料庫時間點恢復的目的GUIIDE資料庫
- Backup And Recovery User's Guide-建立正常和保證的還原點GUIIDE
- Backup And Recovery User's Guide-恢復的取消(並行介質恢復)GUIIDE並行
- Backup And Recovery User's Guide-在還原之前驗證備份GUIIDE
- Backup And Recovery User's Guide-介質恢復問題解決GUIIDE
- Backup And Recovery User's Guide-執行完全資料庫恢復GUIIDE資料庫
- Backup And Recovery User's Guide-從RMAN開始-恢復整個資料庫GUIIDE資料庫
- Backup And Recovery User's Guide-執行RMAN表空間時間點恢復(TSPIRT)GUIIDE
- Backup And Recovery User's Guide-預覽在還原操作中使用的備份GUIIDE
- Backup And Recovery User's Guide-改變塊改變跟蹤檔案的位置GUIIDE
- Backup And Recovery User's Guide-從RMAN開始-顯示預設的RMAN配置GUIIDE
- Backup And Recovery User's Guide-歸檔日誌在預設位置的恢復GUIIDE
- Backup And Recovery User's Guide-使用者管理的介質恢復概覽GUIIDE
- Backup And Recovery User's Guide-閃回和資料庫時間點恢復的基本概念GUIIDE資料庫
- Backup And Recovery User's Guide-閃回日誌關閉時的保證的還原點的日誌GUIIDE
- Backup And Recovery User's Guide-開啟和禁用塊改變跟蹤GUIIDE
- Backup And Recovery User's Guide-備份歸檔重做日誌檔案GUIIDE
- Backup And Recovery User's Guide-使用RMAN備份歸檔重做日誌GUIIDE
- Backup And Recovery User's Guide-從RMAN開始-恢復表空間GUIIDE
- Backup And Recovery User's Guide-從RMAN開始-指令碼化RMAN操作GUIIDE指令碼
- Backup And Recovery User's Guide-從RMAN開始-備份資料庫GUIIDE資料庫
- Backup And Recovery User's Guide-從RMAN開始-概覽RMAN環境GUIIDE
- Backup And Recovery User's Guide-覆蓋歸檔日誌目的地GUIIDE