Importing and exporting Oracle DMP files under Linux

1. Exporting DMP Parts

Command: Exp qgtg/\ "[Email protected]\" File=/usr/fuck.dmp

Exp qgtg/\ "[email protected]\" File=/usr/fuck.dmp full=y, more than a full=y, pop-up dialogue output Yes

The export user name is QGTG, and the password is QGTG,SID for all tables under ORCL to the USR directory of the local Linux

Enter the Oracle database user name password, enter, and export successfully as

If you export only one table, the command is as follows:

Exp qgtg/\ "[email protected]\" file=/usr/fuck1.dmp tables= table name

2. Importing Oracle DMP Files

We'll import the DMP from the previous step into the Oracle build table in another Linux,

Upload the previous step of DMP to the Linux system (/usr/download path)

The command is as follows: Imp hdnav/\ "[Email protected]\" File=/usr/download/fuck.dmp full=y

Read DMP from/usr/download path to a database with user name Hdnav and password Qq564425,sid to Hdnav

To view the database, the table has been successfully built.

Importing and exporting Oracle DMP files under Linux