Recovery problem

From: Santhinathan Kumar <kumarsa_at_webtv.net>
Date: Sun, 27 Dec 1998 18:12:22 -0500 (EST)
Message-ID: <15652-3686BED6-285@newsd-271.iap.bryant.webtv.net>

Hello,
I have a problem where in my database, I accidentally dropped two tables. I don't have ANY backups (neither hot nor cold) of the database, but what I do have is the complete archivelog starting from day 1. Is there a way I can use these logs to restore to a point just before I dropped the two tables. Since I don't have a starting poing, I don't know how I can do it. Won't the SCNs give me a problem if I tried to do so using
'recover database until cancel using backup controlfile';

Please help! I am dealing with Production data!

S. A. Kumar Received on Sun Dec 27 1998 - 17:12:22 CST