Oracle Imports DMP files with IMP record

--------------------------------------------------------------------------------------------------------------- --------

This afternoon, a colleague through the DOS import DMP file, has been in the Sqlplus interface constantly enter the user name, password, the interface has always prompted the protocol adapter error!

Look at his anxious appearance, I went to look, suddenly silly, asked him how to import the exported data How to guide, he said that is also through this way, do not know why today has been to enter the user name and

Password, clearly the user name and password is correct, is always prompt protocol adapter error.

OK, just enter the import statement in Cmd No, it's OK, what's the sqlplus?

———————————————————-------------------------------------------------------------------------------

The DMP file is a partial data table that is directly exported via the PL/SQL tool, the file name is 201409091536.dmp, and the D disk is temporarily released

DMP files exported through PL/SQL and data to be imported to are not the same database, the source database tentatively a target database tentatively B

is to import some tables from the a library into the corresponding table in the B library, the table names in the two libraries are the same

Import Start-----------------------

(1) Enter CMD in the Start menu, do not need to switch to Sqlplus

(2) Imp username/password @sid (SID is an identifier that can be viewed through the Computer Management Service to SID) File=d:\xxx\201409091536.dmp

fromuser= user name in librarya touser=B library username tables= (table 1, table 2) ignore=y

Oracle Imports DMP files with IMP record