Backup - Datapump

Create an oracle directory

create the default data pump directory

Export

Import

Create an oracle directory

create directory my_dir as '/home/oracle/andyb';

create the default data pump directory

create directory data_pump_dir as '/u01/ora_backup/datapump';

Export

expdp system/****** schemas=andy dumpfile=andy.dp directory=my_dir

Import

impdp system/****** schemas=andy dumpfile=andy.dp directory=my_dir