Q

How to import/export Oracle dump file from Windows to Solaris

Can you give me the command prompt to import and export a dump file from Windows 2003 to Sun Solaris?

Can you give me the command prompt to import and export a dump file from Windows 2003 to Sun Solaris?
There are many options to your export and import utilities. Basically, to perform a full export of your entire database, do the following:
exp userid=system/manager file=my_dump.dmp 
log=my_dump.log full=y
Once you have the dump file, FTP the file in BINARY mode to your new database server. Then import the dump file's contents as follows:
 
imp userid=system/manager file=my_dump.dmp 
log=imp.log full=y
For more options for these utilities, refer to the Oracle Utilities Guide for your version.
This was first published in July 2007

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close