Common Trouble Solution--CASE NE…

scenario:
<wbr><font style="font-size: 18px;"><wbr> database operates in ARCHIVELOG mode. User-managed consisten<br> t backups are performed every Sunday night. <wbr><br> On Tuesday, client A drops a table at 8:00 a.m. as follows: <wbr><br><br> SQL&gt; DROP TABLE cust_ord PURGE; <wbr><br> Table dropped. <wbr><br> Client B executes a query at 9:00 a.m. on the same table as follows: <wbr><br><br> SQL&gt; SELECT * FROM cust_ord; <wbr><br> SELECT * FROM cust_ord <wbr><br> ERROR at line 1: <wbr><br> ORA-00942: table or view does not exist <wbr><br><br> Client B needs the dropped table and reports the problem to you. <wbr><br><wbr>which action should we take? <wbr><br><br> Action: restore all the data files from last Sunday's backup and then perf<br> orm a time-based recovery <wbr><br><br><br><wbr><wbr> NOTE:表被删除，同时 purge 从 recycle bin 中，无法使用闪回来闪回表，只能基<br> 于 scn 或时间的不完全恢复,因为是不完全恢复，必须基于数据库级，而且已经<br> 知道时间要恢复的时间了,所以 recover all data files 基于时间的不完全恢复。</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></font> </wbr>