What is the dmp file in oracle?

In Oracle, the dmp file is a file exported from the database and is often used for database backup and migration; for example, when importing a dmp file, you need to first store the dmp file in the dump path and use "imp dp username /Password@orcl...The name of the dmp file that needs to be imported" command can be imported.

The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.

What is the dmp file in oracle?

is a database file exported from the oracle database and is often used for database backup and migration. Generally, the exp command is used to export, and the imp command is used to import, that is, to restore the database.

2. Export (backup) dmp

Usually when the requirements of a project are updated, the content of the Oracle database will also change accordingly. Therefore, it is necessary to Make a backup of the old Oracle database data so that it can be restored if needed in the future.

The specific operation process is as follows:

1. First find the location where the backup file is stored, that is, find the path location where dmp is stored by default

(1) Enter the linux system and enter At this time, we are the root user. At this time, we need to switch to the oracle user,

su - oracle

(2) Enter sql

sqlplus / as sysdba

(3) Enter the query sql statement

select * from dba_directories where directory_name='DATA_PUMP_DIR';

The output result is: /home/oracle_11/app/admin/orcl/dpdump, the path is found!

2. Execute the database backup command

expdp （用户名）/(密码）@orcl dumpfile=expdb_isc_20211012.dmp(自定义命名.dmp)

After entering the command, the custom named dmp file will be stored in the above path to complete the backup. After completion, you can view the backup file under the above path.

3. DMP file import

is often used for database migration. When an additional new server needs to be deployed, the dmp file backed up in advance needs to be imported into the new server. Environment.

1. Before importing, we need to create a new user to store our dmp data

New user command:

create user (用户名) identified by (密码)

() The content inside is our own Define the user name and password, and grant permissions to the user after creating the new one.

grant dba to (用户名)

If you are not sure after the new creation, you can check whether the new one is created. Execute the following sql. If the output result contains our newly created user name, it means Already created.

 select username from dba_users;//查看oracle所有用户

Do this step well so that we can import the dmp file.

2. Before importing, we need to store the dmp file in the dump path. We can use FileZilla software to connect sftp to our server address and transfer the local file to the corresponding path of the Linux system.

3. Execute the import command

impdp (用户名)/(密码)@orcl  dumpfile=ISC2220210702.DMP(需要导入的dmp文件名)

At this point, the import of dmp is complete!

Recommended tutorial: "Oracle Video Tutorial"

The above is the detailed content of What is the dmp file in oracle?. For more information, please follow other related articles on the PHP Chinese website!