Q
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=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.

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.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close