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?
Best Answer
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.