Re: How to restore records from one table only?

From: Gerard H. Pille <gerard_h_pille_at_hotmail.com>
Date: 1997/06/04
Message-ID: <01bc7128$14fd33e0$3e0d4ac1@pcghp>#1/1

I'm afraid you can't, you would need an export file, not a backup. You could include an export in your backup-strategy, to be able to fix "programming errors" afterwards. From the backup, you could then retrieve only the export-file, not the entire database.

Mr. Alan Kong <kkkong_at_ee.cuhk.edu.hk> schreef in artikel <338FD497.DF5_at_ee.cuhk.edu.hk>...
> 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
>
Received on Wed Jun 04 1997 - 00:00:00 CDT