Several ways for Oracle to import database dmp files

Import using the cmd command

Enter cmd Direct input command

IMP username/password @ Listener path/Database instance name file= ' d:\ database file. dmp ' Full=y ignore=y

For example:

Imp Mislogin/mislogin@localhost/jfjoa file= "D:\data.dmp" Full=y ignore=y 

using Oracle's Bin directory imp.exe import

Open Oracle Home Directory
E:\app\shaoduo\product\11.2.0\dbhome_1\BIN
Find Impdb.exe for import
Run with the administrator identity. Enter the password, enter the password and then enter the path of the DMP, what will appear behind the "no" to see the situation input into the return. Import using the Pl/sql Tools tool

Import can

Copyright notice
Author:shaoduo
Original from: http://blog.csdn.net/shaoduo/article/details/70942016
Other sources are reproduced, original works, welcome to criticize the reader.