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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Missing datafiles

Re: Missing datafiles

From: Dennis Williams <oracledba.williams_at_gmail.com>
Date: Fri, 29 Jun 2007 09:33:41 -0500
Message-ID: <de807caa0706290733v56e7acabw5d62b4819bb0d397@mail.gmail.com>


Kanwar,

Based on the limited information you provided, here is another possible route for you to consider, depending on your situation and your success with the method that Pat has described:
If you still have the original datafiles (maybe on a backup),

  1. Create the database on a test server as you had originally planned, including the missing datafiles.
  2. Determine the missing data. If there are full tables missing, exp/imp them to the new database. If there are missing rows, exp them using the query option.
  3. Import the missing data into the new database.

Dennis Williams

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jun 29 2007 - 09:33:41 CDT

Original text of this message

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