Ask the Expert

How to use the Oracle import utility 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.

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

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: