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