1 2 Previous Next 15 Replies Latest reply: Nov 27, 2012 11:29 PM by saurabh Go to original post RSS
      • 15. Re: impdp errors
        what you need to do first is create all the tablespace in your production database. If you dont know the same then what you can do is. use the following command to get all the ddl statements that are going to be executed.

        impdp username/password dumpfile=file_name.dmp directory=directory_name sqlfile=file.txt

        this command will create a sqlfile. As this is a text file you can view. In this file you will find all the information you need like how many users are there and their create statements. In this you will find their default tablespace name.

        Now create those tablespace all of that and then import your dumpfile on it. You need not to worry about the users as they are going to get created automatically with their privilages and role.
        1 2 Previous Next