Data Pump for Oracle data migration to a remote database

Today, we found that the impdp command has a special purpose. You can migrate one user of the database to the user of the database on another machine. If the target user does not exist

Today, we found that the impdp command has a special purpose. You can migrate one user of the database to the user of the database on another machine. If the target user does not exist

Today, we found that the impdp command has a special purpose. You can migrate one user of the database to the user of the database on another machine. If the target user does not exist, you can create the user accordingly.

The command format is as follows:

Impdpusername/passwd @ dbsnameremap_schema = userA: userB remap_tablespace = tbsA: tbsB network_link = dblink_to_userA_on_userB

Note:
Userid: Username/passwd @ dbsname. We recommend that you use system.
Remap_schema: userA: userB. Database User ing.
Remap_tablespace: tbsA: tbsB. Default tablespace ing.
Schemas: userA. The user must be specified in dblink. We recommend that you do not specify this parameter.
Directory: In this mode, this parameter specifies the path of the log file. If not specified, the default path is data_pump_dir.
Network_link: The dblink created on the backup database to connect to the target machine.

In this way, users in database A can be quickly migrated to database B.

However, there are several prerequisites:

1. username: the database user for this operation is recommended to be system. If it is another user, it must be executed by a user with dba permission;

2. dblink: You must be able to connect to the database user in the corresponding database.