If you have a dump file created from an Oracle export utility, then you first need to transfer the file to the...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
Windows server. If you are using FTP to transfer the file, then make sure that you FTP in BINARY mode. I'm going to assume that you've installed the Oracle software and precreated an Oracle database on this server. The next steps are as follows:
- Precreate any tablespaces you will need to hold the data to be imported.
- If the export dump is not a FULL export of the source database, then you will need to precreate the users to hold the data.
- Import the data with the imp utlity:
imp userid=system/manager file=export.dmp full=y log=imp.log
If there are errors, they will be shown in the log (imp.log). The FULL=Y parameter tells the imp utility to import the entire contents of the dump file.
The Oracle docs give much more information on the export and import utilities. You can find a copy of this documentation at the following URL:http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/toc.htm
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
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
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.