Q

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 first published in August 2009

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close