Ask the Expert

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?

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: