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: restoring row entries from a database

Re: restoring row entries from a database

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Wed, 27 Dec 2000 19:40:40 GMT
Message-ID: <3A4A45B8.8212F881@edcmail.cr.usgs.gov>

This isn't exactly a "supported" feature of the Oracle databases. But if you are running Oracle 8i, then you could do something like:

  1. Use Logminer to generate the DML commands to restore your certain rows
  2. Restore from a previous backup.
  3. Use the DML from step 1 to do the actual restore.

HTH,
Brian

kaprino_at_my-deja.com wrote:
>
> Can you restore certain rows in a table database instead of a complete
> table? If so what steps must be taken?
>
> Regards,
>
> kaprino
>
> Sent via Deja.com
> http://www.deja.com/
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================
Received on Wed Dec 27 2000 - 13:40:40 CST

Original text of this message

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