Re: How to restore records from one table only?

Mr. Alan Kong wrote:
>
> Hi,
>
> I am new to Oracle DB admin.
>
> I accidentally deleted records from a table and wonder whether someone
> could advise me on getting the deleted records back.
>
> I have a backup from the previous night which was backed up with the
> Back-up manager. Could I restore just that table? I have never done a
> restore before. I wonder whether you could advise.
>
> Thanks very much in advance.
>
> Regards
> Alan

1. if your backup is an EXPORT type backup, then you can IMPORT that table. But since this would have been easy enough for you to figure out then I have to assume that you have only a hot or a cold backup ... so
2. if you have enough disk space, you can restore your database from your backups to a new database. From there, you can export the data you want.
3. if you don't have enough disk space, and you can take your database out of service for a few hours, try this:
4. cold backup your database
5. restore the database from your OLD backup. Export the table
6. restore your database from your most recent backups.
7. import the table data

Good luck.

Wayne Linton
Shell Canada Ltd. Received on Sun Jun 01 1997 - 00:00:00 CDT