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: Datapump and read only database

Re: Datapump and read only database

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Wed, 30 Aug 2006 17:45:37 GMT
Message-ID: <J4to05.E5@igsrsparc2.er.usgs.gov>


> In these cases the only chance is to import the table from backup into
> another schema and fix the deletes.

That may not be the only option...if you are running in Archivelog mode, you can also use LogMiner to reconstruct the INSERT statements to get those rows of data back.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown
Received on Wed Aug 30 2006 - 12:45:37 CDT

Original text of this message

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