Oracle Data Pump import/export syntax

Oracle Data Pump import/export Syntax 1. first create a directory: www.2cto.com create directory name as 'a directory on the database server ', such as: create directory alias as 'd: \ Server Directory name'; put the imported or exported files in this directory. 2. Export and Import files with SID = orcl. The exported dmp account is test, the account for importing dmp is test. If you export data from sfz: expdp test/test @ orcl directory = alias dumpfile = export file name to test: impdp test/test @ orcl directory = alias dumpfile = export file name. when the dmp import usernames are different everywhere, do a ing. When the same, do not write remap_schema = test: test1.