Manage Learn to apply best practices and optimize your operations.

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.

Dig Deeper on Oracle database backup and recovery

SearchDataManagement
SearchBusinessAnalytics
SearchSAP
SearchSQLServer
TheServerSide.com
SearchDataCenter
SearchContentManagement
SearchHRSoftware
Close