Introduction to oracle Data Pump Import and Export

1. First create a directory:

Create directory name as 'a directory on the database server ', for example:
Create directory alias as 'd: \ Server directory name ';
Put the imported or exported files in this directory.

2. Export and Import
Take SID = orcl as an example. The account for exporting dmp is test, and the account for importing dmp is test.

If you export data from sfz:
Expdp test/test @ orcl directory = alias dumpfile = Export File Name

Import to test:
Impdp test/test @ orcl directory = alias dumpfile = export file name. dmp
Perform a ing when the user names are different everywhere for import.
Remap_schema = test: test1