Re: Missing datafiles

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

Other related posts: