You apply the log files to the point just before the table was dropped. That would be an incomplete recovery, b'cos anu changes that had taken place after this point on other tables would be lost. The best is clone the db from the backup. Do an incomplete recovery on the backup to the point the table was dropped, on the clone db. Then export that table space and import it into the production db. You are set.
Sam




Reply With Quote