Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to restore records from one table only?

Re: How to restore records from one table only?

From: Ken Ridgway <ken_at_fifthd.ca>
Date: 1997/06/02
Message-ID: <3393dba6.2309024@news.sas.ab.ca>#1/1

Hi.

Use the import utility. You do not mention your O/S so the utiltiy will either be IMP or IMP32.

The following should be close to what you need to do but you should check the Server Utilities Manual for the correct syntax.

Good Luck.

imp user/password file=backup.dmp ignore=y rows=y tables=table_you_need

The user/password should be the table owner. You might want to include the option commit=y this will commit periodicaly as it imports the data and requires less rollback space.

Hope this helps.
Ken.

On Sat, 31 May 1997 15:34:47 +0800, "Mr. Alan Kong" <kkkong_at_ee.cuhk.edu.hk> 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
Received on Mon Jun 02 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US