FLASHBACK TABLE table_name TO BEFORE DROP;If you are using a version prior to 10g, then your only option is to restore the database from your hot backup and roll forward just prior to the point in time the table was dropped. You will lose all database transactions since that point in time.
Dig deeper on Oracle database backup and recovery
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.