How to import oracle database dump using command prompt

go to command prompt and fire the below the command
c:/databasedumpfolder:> imp system/admin@XE fromuser=sanjit_ipa touser=sanjit_ipa file=”sanjit_ipa_new.dmp”
In this command
system is id,
admin is password,
from user is user of dump file,
to user is the new user to which database dump will be assigned
file=”<dump file name>” is dump file name which is there in the folder from where command is fired.

2 thoughts on “How to import oracle database dump using command prompt

  1. MY CURRENT DATA IS IN ORACLE AND IT CONTAIN IMAGE FILE IN BINARY FORMATE I WANT TO CHANGE MY DATABAS BUT WHEN I IMPORT DATA IN SQL SERVER THE BINARY DATA GIVES ERROR IF ANY SOLUTION PLEASE MAIL ME

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s