Importing Oracle. dmp files with cmd

1, first create the user

syntax [Create users]: Create user username identified by password [i.e. password];

Example: Create user zhengxin identified by Zhengxin;

2. Giving the User DBA Authority Grant DBA to Zhengxin

3. Open cmd command line

Syntax: MP username/password @ host IP: Port number/instance file=dmp the path where the file is located full=y.

Input: Imp zhengxin/[email PROTECTED]:1521/ORCL file= "e:\ personal Business Number
According to. DMP "FULL=Y;

Example:c:\users\administrator> imp zhengxin/[email protected]:1521/orcl file= "e:\ personal Business Number
According to. DMP "FULL=Y;

The data is then imported successfully.

Importing Oracle. dmp files with cmd