Manage Learn to apply best practices and optimize your operations.

How to use the Oracle import utility when importing a dump file

Oracle expert Brian Peasland explains where to run the Oracle command and use the Oracle import utility to see parameters when importing a dump file.

One of your previous questions mentioned the method of importing a .DMP dump file into a local database. Could you please explain where I should run the command, and the details of the parameters? I use Oracle version 10.2.0, and the dump has been taken from the same version database.
You run the command from the command line on your database server. The dump file needs to reside on your database server as well. To see the parameters, and examples on how to use the import utility, refer to this Oracle import utility document.
This was last published in August 2009

Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.