Example of Oracleexpdp and impdp

Due to production requirements, you need to copy the rmtel user data to rmtel_xzy, but exclude the rmtel user (

Due to production requirements, you need to copy the rmtel user data to rmtel_xzy, but exclude the rmtel user (

Scenario:

Due to production requirements, you need to completely copy rmtel user data to rmtel_xzy, but exclude rmtel users ('cab _ JJXPORT_TAB ','t _ servicexx', 'tb _ crossconnection ', 'tb _ link', 'tb _ card', 'tb _ physicaliner iner ', and 'tb _ port. That is to say, the data structures of these two users must be exactly the same, except for these tables. The data is stored in the rmtel_xzy tablespace.

The procedure is as follows:

1: Use the administrator user sys to create a directory and grant permissions to relevant users.

A: query the export directories in the database: select * from dba_directories;

B: create the export directory: create directory RMTEL_DIR as 'd: \ rmtel_dump ';

C: authorize the export directory to the operation User: grant read, write on directory RMTEL_DIR to rmtel_xzy, rmtel;

2: Use the windows doc window to export rmtel data

3: Use the windows doc window to import data

The exclude and include parameter values of Oracle expdp and impdp tools are different in different environments. Note that if you create and execute these backup tools in the doc file in Windows, you can install the above operations successfully.

Related reading:

Key Points of migrating 11G data to 10g platform through expdp & impdp

Oracle Data Pump examples and some precautions (expdp/impdp)

Oracle datapump expdp/impdp hang

Expdp/impdp for Oracle 10g to 11g data migration