Re: Recover a table

Dennis

Bad luck. Once you drop a table you can't rollback, because the DROP TABLE command is DDL.

There are two possible ways to recover:

1. If you're running in ARCHIVELOG mode, do a point in time recovery until just before the drop command. To minimize loss, restore the database somewhere else than Production and do the recovery there. Then export the table, import back to Production. You need to be careful of any master detail relationships though. If you're running in NOARCHIVELOG mode, you need to restore the last backup and do the export from that.
2. If you have an export, import the table from that. Same provisos apply.

HTH. Pete

Dennis wrote:

> Dear all,
> I dropped an important table accidentally. Is it can be recovered?
> If yes, how? Thanks!
>
> Dennis

Received on Thu Dec 23 1999 - 11:19:46 CST