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

Can I create a new instance in a new server and import a dump file which was made with the command exp full=y etc?

If it is possible do I need to recreate tablespaces and users before the import? If yes can I find these two from the dump file alone?

share|improve this question
Are you just looking for a Yes/No answer (which would be "yes"). Or is there more to your question? – Justin Cave Oct 24 '12 at 10:02
Well if its possible I will do my research and try to make it happen! If you have any pointers to make my life easier I would be thankful though. – Alexk Oct 24 '12 at 10:05

If you do a full import, the import will attempt to create all the tablespaces and data files exactly as they existed in the source system. If you want exactly the same data files on exactly the same locations, you're all set. If you want the data files to be in different locations, you would need to create the tablespaces before doing the import.

If you do a full import, the import will create all the users.

share|improve this answer
Should i create the users first in the new db? That would be a problem since all i have is the dump file. – Alexk Oct 24 '12 at 10:26
@Alexk - Updated my answer. – Justin Cave Oct 24 '12 at 10:28
you will get a lot of error meassages and it will be hard to decide if they are important or can be ignored – miracle173 Oct 24 '12 at 20:11
@miracle173 - What errors are you referring to? A full import should import cleanly assuming that you either want a physically identical database or that you properly pre-create the tablespaces with the new data files before running the import unless there were issues in the source database (i.e. objects that couldn't compile successfully in the source database) or where a non-consistent export was generated from a database that was still being actively used. – Justin Cave Oct 24 '12 at 21:10
i will need some time to create an appropriate test case – miracle173 Oct 29 '12 at 23:30

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.