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?

  • 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.

  • 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 clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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