创建一个directory对象,指定备份的目标磁盘位置
SQL>create directory myback as 'd:\oraclestudy';
为scoot用户授予使用该目录的权限
SQL>grant read,write on directory myback to scott;
备份数据库:expdp
C:\Users\Administrator>expdp scott/1231234 directory=myback dumpfile=dbbacktest.dmp full=y;
恢复数据库:impdp
C:\Users\Administrator>impdp scott/1231234 directory=myback dumpfile=dbbacktest.dmp full=y;