Dump Data Pump Import and Export (concurrent)

Simple Import and Export Statements:

Parafile = paramter. DAT 2G tablespace = 1.2 gdmp
SXG user example dumpdir = D: \ backup \ dmp

SQL> Create dircetory dumpdir as 'd: \ backup \ DMP ';
SQL> grant read, write on directory dump_dir to SXG;

Export data in parallel:
Bin> expdp SXG/[email protected] Directory = dumpdir dumpfile = sxg_20140101 _ % u. dmp log = D: \ backup \ DMP \ SXG. expddlog filesize = 6g parallel = 10

Import data in parallel:
Bin> impdp SXG/[email protected] Directory = dumpdir dumpfile = sxg_20140101 _ % u. dmp

Parallel = 10 log = D: \ backup \ DMP \ sxgimpdp. Log

User or tablespace change
Remap_shema = (A: B)
Remap_tablespace = (ts_a: ts_ B)

Dump Data Pump Import and Export (concurrent)