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

    Login

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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top