Backup - Datapump

Backup - Datapump

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