Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

After a system failure I bought a new server and now I'm trying to recreate the Oracle database I had.

I have a dump file which was made with the command exp and full=y. Can I restore the full database from this dump? If yes, how?

Oracle 11g on Windows server 2003.

share|improve this question
watch my answere here on serverfault… – cljk Oct 22 '12 at 18:46

It seems you used the old import utility (with 11g you should use the DataPump), then:

imp "/ as sysdba" file=<dumpfile> log=<logfile> full=y

If I remember well, old export utility in 11g doesn't save empty table, due the "deferred segment creation". Make a check after the import.

share|improve this answer
+1 for deferred segment creation – Roy Nov 22 '12 at 14:09

This bat script must be located in the same folder as the dump file which should be on a folder off your main drive for convenience sake.

imp userWithDBAPrivileges/password LOG =C:\dump\logs\import.log file =yourDumpFile01.dmp fromuser=user1 touser=user1

As Goliardico points out you have to have the same tablespaces and users but the users cannot have any objects with the same name as objects to be imported. The caution about empty tables is also applicable and a real gotcha if you don't notice.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.