Bab... U r in trouble... Restore it from the last export if it is static table.
If it is dynamic... Restore the database from latest backup.. And apply all the logs till you dropped and export that table alone...
And import it into prod...

All the best..
RD


-----Original Message-----
From: Carlton, Kristina [mailto:[Email Address Removed]
Sent: Friday, February 27, 2004 3:42 PM
To: LazyDBA.com Discussion
Subject: drop


I wish drop wasn't so final. I just dropped tables from PROD. UGH!




DISCLAIMER:
The information in this message is confidential and may be legally privileged. It is intended solely for the addressee. Access to this message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful. Please immediately contact the sender if you have received this message in error and delete the material from any computer. Thank you.

Oracle LazyDBA home page