SQL> shutdown abort .com

About DBA Queries DBA Scripts Quick Guides Nooleus Other Stuff Contact
Andy only 
 

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
Copyright© 2007-2010 Andrew Barry