oracle学习笔记（二：数据库的备份和恢复）

创建一个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;

 

转载于:https://www.cnblogs.com/oraclelast/p/11327749.html