I have a dump file on my local C drive. I want to import to an Oracle database. Where to write the imp command? Is it on the command prompt or on SQL*Plus?

    Requires Free Membership to View

    Login

The import utility is a command line utility just like SQL*Plus or other command line utilites. This document contains all of the information you will need on the imp utility.

As an example, to import the entire contents of your dump file, you can use a command similar to the following: 

imp userid=system/manager file=mydump.dmp full=y log=imp.log

This was first published in April 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top