Importing dump files from Unix to Windows

The best source of information on Oracle's export and import utilities, including the Oracle 10g Data Pump utilities, is the Oracle documentation, specifically the Oracle Utilities Guide. Chapter 19, Original Export and Import, talks about the typical exp and imp utilities. The first few chapters talk about the newest versions of export and import, Oracle 10g's Data Pump utilities.

If you have a dump file, then you can import the entire contents of the dump with the following command:

imp userid=system/manager file=my_dump.dmp log=imp.log full=y

You must sign on to the database with a user that has the privileges to create objects in other schemas, like the SYSTEM user. I log my import session to a log file so that I can review it for errors. The FULL=Y parameter will import the entire contents of the dump file.

Depending on how the dump file was created, you may have to create tablespaces and users before you import the contents of the dump file.