Import a. dmp file into the Oracle database on a Linux machine

First, if there is plsql can be in the tool-Import table--oracle Import-Add executable file can be imported.

Second, using WINSP to upload the dmp file to Linux, the Linux Command window switch to the Oracle user, enter SQL Plus, you can choose to create a table space to build a user, or directly create a new user to adopt the default table space.

Create user WWH identified by 123456

Grant connect to WWH;

Grant resource to WWH;

Grant CREATE view to WWH;

GRANT DEBUG any PROCEDURE to WWH;

Grant Imp_full_database to WWH;

Create users and give users relevant permissions;

Final execution

Imp wwh/123456 file=/root/desktop/sit33s.dmp ignore=y full=y

Address of username/password file on Linux

Import a. dmp file into the Oracle database on a Linux machine