Common Trouble Solution--CASE NE…

scenario:
  database operates in ARCHIVELOG mode. User-managed consisten
t backups are performed every Sunday night. 
On Tuesday, client A drops a table at 8:00 a.m. as follows: 

SQL> DROP TABLE cust_ord PURGE; 
Table dropped.  
Client B executes a query at 9:00 a.m. on the same table asfollows:  

SQL> SELECT * FROM cust_ord; 
SELECT * FROM cust_ord  
ERROR at line 1:  
ORA-00942: table or view does not exist  

Client B needs the dropped table and reports the problem to you. 
 which action should we take? 

Action: restore all the data files from last Sunday's backup andthen perf
orm a time-based recovery  


   NOTE:表被删除，同时 purge 从 recyclebin 中，无法使用闪回来闪回表，只能基
于 scn 或时间的不完全恢复,因为是不完全恢复，必须基于数据库级，而且已经
知道时间要恢复的时间了,所以 recover all data files 基于时间的不完全恢复。