Restore table

[richardtsa]

How do a person go about restoring a table.

I drop a couple of tables by mistake

I have arc log, but no luck in restoring anything from them

any help would be appreciated

 

[karluk]

Do you have a database backup that you can use for a recovery? If not, you are probably out of luck. If you can recovery the database on a test server, you can then export the dropped tables and import to your production database.

Alternatively, you could do a point-in-time recovery of the entire production database to a point prior to dropping the tables. That assumes that you can afford to lose all updates to other tables that happened after the drops.