Answer

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?

Published: 09 Jul 2007

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.

Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading

One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading

Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading