Problem solve
Get help with specific problems with your technologies, process and projects.
Importing dump files from Unix to Windows
I am new to Oracle 10g on Windows. How to import dump files taken for Oracle 10g under Unix? Can anyone provide steps or direct me?
I am new to Oracle 10g on Windows. How to import dump files taken for Oracle 10g under Unix? Can anyone provide steps or direct me?
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=yYou 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.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments