By
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.
Dig Deeper on Oracle database backup and recovery
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