Q
Problem solve Get help with specific problems with your technologies, process and projects.

Where to write the imp command?

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?

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?

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

Dig Deeper on Oracle database backup and recovery

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close